luxury property for sale Aubers, France

The notary office SELARL BELLANGER, DARTOIS, PAULISSEN and BAILLOEUIL, SELARL offers you: Property for sale in Interactive Real Estate - - - - - - - - - - - - - - - - - - - - - -Address of the property: 81 Rue Jean Jaurès 59263 HOUPLIN ANCOISNE- - - - - - - - - - - - - - - - - - - - - -Located in the municipality of Houplin-Ancoisne, close to amenities and major communication routes, this property complex in generally good condition is a rare opportunity for an investor, a family wishing to bring together several generations, or a buyer looking for a heritage project.House No. 1 – Approximately 85 m² of living space + convertible atticThis dwelling includes: A bright living room; An equipped kitchen; One bedroom; A shower room; An independent toilet. A convertible attic of about 26 m² offers potential for extension or the creation of complementary spaces according to your needs. Electric heating supplemented by a pellet stove.House No. 2 – Approximately 86 m² of living spaceThis house consists of: A living room; An equipped kitchen; Three bedrooms; A bathroom; An independent toilet. An outbuilding complements this accommodation. Electric heating.House No. 3 – Approximately 120 m² of living spaceThe largest of the three dwellings includes: A living room; An equipped kitchen; Four bedrooms; A bathroom; An independent toilet. It also has a garage. Central gas heating supplemented by a pellet stove.ExteriorsAll three homes benefit from: A communal garden; A shared vehicle access allowing for the servicing and parking of occupants.The strengths: A property complex composed of three independent dwellings; Good overall condition of the homes; Attractive rental potential; Convertible attic; Outbuilding and garage; Communal garden; Plot of 587 m²; Sought-after location in the heart of the Lille metropolis.Interactive Notarial SaleThis property is offered for sale under the principle of interactive notarial sale. Visits are by appointment with the notary office. Information regarding diagnostics, sale conditions, and participation methods is available upon request.Visits on Wednesday, September 16, 2026, between 2:30 PM and 4:30 PM and Saturday, September 19, 2026, from 9:30 AM to 11:30 AM A property complex with multiple operating possibilities, ideal for rental investment, a family project, or the establishment of sustainable real estate assets. - - - - - - - - - - - - - - - - - - - - - -Visits: Wednesday, September 16 from 2:30 PM to 4:30 PM Saturday, September 19 from 9:30 AM to 11:30 AM Contact: 03.20.16.01.85 - - - - - - - - - - - - - - - - - - - - - -Sale conditions: The property is presented in Interactive Real Estate for bidding: - 1st offer possible: starting from 445,000 euros (negotiation fees included) - Following offers: multiples of 5,000 euros. - Reception of offers from 29/09/2026 at 2:00 PM to 30/09/2026 at 2:00 PM on the Immo-interactif® site. - - - - - - - - - - - - - - - - - - - - - -Announcement from the firm SELARL BELLANGER, DARTOIS, PAULISSEN and BAILLOEUIL - Notaries in Phalempin - SIRET No: 78397849700056 - - - - - - - - - - - - - - - - - - - - - -Immo-interactif®: the auction system for real estate without constraints, transparent and secure, offered by your notary.This description has been automatically translated from French.

59236 - FRELINGHIEN - CITY CENTER - BUILDING with 12 rented apartments.- 736 M2 - INTERESTING RENTAL INCOME efficity, the agency that estimates your property online, offers you this character building in the heart of Frelinghien. This building, with a generous area of 736.0 m2, is a rare investment on the market. Former medical house of the congregation of the Oblates of the Eucharist, it was bought in 2010 and completely renovated. This beautiful manor is in excellent overall condition. With three levels, this building has 12 apartments T2 and T3. The cellar has an area of 59 m2. This place is sold rented with a profitability rate of nearly 9%, amounting to €81,000 in annual rental income. Outside, you will benefit from 12 parking spaces, a significant advantage for your tenants. Do not miss this unique investment opportunity. For more information or to schedule a visit, contact me, Eric BAISIER, at 0650818103.

Exclusive. Lille, near the Museum, Rare private mansion with an elegant sculpted facade, built in 1924 by the architect 'Emile Vandenbusshe'. Erected on 5 levels, entirely renovated by an interior designer in 2022, this magnificent private mansion is ideal for mixed use (professional and residential). On the ground floor, access to a very beautiful space of over 150 sqm overlooking a charming landscaped courtyard. This space is enhanced by ultra-contemporary glass roofs that allow natural light into the premises. Its purpose could also suit a gym or a relaxation area with direct access to the outside. Two majestic columns delineate the main entrance of the private mansion. A spacious entrance hall distributes on this level 2 offices. The 1st floor houses a triple reception of approximately 75 sqm composed of a lounge adorned with beautiful orangery windows, a living room with a wood-burning fireplace, and a dining area. Very high ceiling (3.70m), fully renovated parquet flooring, and original moldings. Toilets and cloakrooms. Splendid immaculate kitchen of approximately 20 sqm, fully equipped and custom-made. On the second level, a landing leads to a magnificent master suite. We discover a 'Master room' of 32 sqm with a very nice view of the outside and the vegetation, a splendid full bathroom of approximately 20 sqm, and fitted wardrobes. Separate toilets. On a 1/2 level, a beautiful laundry room and toilets. The 3rd floor consists of a magnificent 26 sqm bedroom with a balcony and its private shower room. A second 20 sqm bedroom with water point and possibility to create another shower room. The 4th level, formerly an attic, houses a beautiful 26 sqm bedroom (on the floor) and its shower room, as well as another space on the landing that can be converted into a 5th bedroom. Complete basement of over 140 sqm, ultra-healthy and composed of many beautiful storage cellars, wine cellar, and boiler room. On the technical side, the private mansion has benefited from a masterful renovation, both in terms of electricity, plumbing, heating system, sanitary facilities, and kitchens, while the decoration, ultra-trendy, is enhanced by lighting effects. A parking space reserved outside the building and the possibility to rent a garage nearby. The location is ideal, right in the city center, close to shops, restaurants, boutiques, transport, and the Lille Flandres and Lille Europe train stations.

Property complex, located in the Vieux Lille sector, near train stations, with a total approximate surface area of over 1300 m2, composed of: - 3 apartments of 93m2, one of which is currently designated as offices. - 1 duplex-style Loft apartment of 290 m2 with a rooftop. - 1 office space of 103 m2 - 2 studios of 40 and 30m2 - 1 ground floor space functioning as a garage of 85m2 - Several basement spaces of 287m2. - 1 'commercial' space of 95m2. This composition represents several lots and different designations in the property report. The constructions are spread over 2 adjoining buildings: - 4 levels (including R-1) of approximately 200m2 each - 5 levels (including R-1) of approximately 95m2. Plans available upon request.This description has been automatically translated from French.

Co-Exclusive Listing. Located in Lille Royale, just steps from the Grand Place and the bustling shops of Old Lille, this rare and sublime mansion was built in the late 17th century and remodeled in the 18th and 19th centuries. Access is through a beautiful carriage door leading to a large inner courtyard, providing parking for 3 or 4 vehicles and featuring 2 garages on either side of the main entrance. The charming street-facing facade from the mid-19th century, adorned with a lovely wrought-iron balcony, houses a completely independent Type 4 unit, perfect for an office. The main mansion, at the back of the courtyard and adorned with a beautiful glass canopy, is spread over three levels with a pleasant layout. The entrance is through a spacious blue stone hall that opens to the right onto a large living room with finely gilded Louis XVI woodwork, featuring a Mondrian-inspired rhythm of great quality. On the garden side, a second living room with a wood-burning fireplace and a spacious dining room offer a peaceful view of the terrace and garden. The individual kitchen, located on the courtyard side, is equipped and decorated with old tiles, reflecting the house's origins. All reception rooms feature superb herringbone oak parquet floors and impressive ceiling heights (4.20 meters). Access to the upper floors is via an elegant staircase with a stunning skylight designed by architect Carlier in the 1980s. On the first floor, the garden side hosts a magnificent master suite with a spacious bedroom, dressing room, and a complete bathroom connected to a second bedroom overlooking the garden. The courtyard side has two beautiful bedrooms, each with its private bathroom. Most floors are adorned with beautiful solid elm parquet. The second floor includes four charming bedrooms, each with a distinct style, including two with private bathrooms. The mansion is partially excavated and has ample storage cellars, a wine cellar, and a vast attic. The garden side features a beautiful facade of Poitiers stone. The perfect exposure and well-treed garden allow full enjoyment of the tranquility of this exceptional location, free from any noise disturbances. The property also includes two garages and a lovely inner courtyard with parking for 3/4 vehicles, as well as six cellars. The location is unique, on one of the most beautiful streets in Old Lille, just steps from schools, transport, the Grand Place, and the chic restaurants and boutiques of Old Lille.

Located in the heart of the Marbrerie district, just minutes from Lille’s city center, this single-ownership investment property (approx. 460 m²) enjoys a highly strategic location. It is situated right next to the Marbrerie metro station and major thoroughfares, offering quick access to Fives, Hellemmes, Lille’s train stations, and the city center. Built in the late 19th century, the building features a layout ideally suited for a rental investment (comprising 27 furnished studios) and benefits from the dynamic growth of this Lille neighborhood—an area highly sought-after for its accessibility and proximity to university hubs, business districts, and metropolitan transport links. Proximity to the metro is a major asset for renting, while the immediate surroundings offer a range of shops and everyday services. The neighborhood also benefits from the ongoing transformation of eastern Lille and its excellent connectivity to the heart of the metropolis. This property represents an attractive investment opportunity for anyone looking to acquire an income-generating asset within Lille proper, offering potential for capital appreciation driven by both rental demand and the area's continued development. A rare asset in Lille combining prime location, rental potential, and long-term value—ideal for an investor seeking an income-producing property in a highly dynamic metropolis. Estimated gross annual rent: €130,000 – €145,000.

In a peaceful and sought-after environment, on a plot of over 2397 m², discover this magnificent fully renovated Flemish house with quality finishes. From the entrance, you will be charmed by its beautiful living room bathed in light, open to a fully equipped kitchen, ideal for sharing pleasant moments with family or friends. The ground floor also includes a bedroom, two bathrooms, and a laundry room. Upstairs, the night space offers 4 lovely bedrooms. Outside, enjoy a superb wooded garden facing SOUTH-WEST!! Private parking spaces and garages complete this set of features.This description has been automatically translated from French.

Mouvaux Limit: Splendid Character Hotel on 2,500 m²On the edge of Mouvaux, in a sought-after area and in immediate proximity to the tram, public transport, and schools, discover this exceptional early-century hotel, built on a 2,500 m² plot. This exceptional property combines architectural prestige, rare volumes, and high potential for mixed-use, both as a prestigious main residence and for professional activities such as liberal or tertiary professions.From the entrance, the tone is set: a majestic hall with natural stone and wrought iron railings leads to the reception areas on the ground floor, including:A bright 45 m² living roomAn intimate 13 m² libraryA second 40 m² living roomA large 40 m² kitchen, combining oak parquet floor and antique tiles (layout to be finalized)The whole is enhanced by stunning 18th-century stripped oak woodwork, giving elegance and authenticity.A mezzanine with direct access to the garden offers a 45 m² room (to be renovated), ideal for an independent space or a professional office.Upstairs, there is a spacious 35 m² master suite with a fireplace, arched doors, a dressing room, and a bathroom, complemented by four other bedrooms of approximately 25 m² and a second bathroom.The upper level offers an attic of 250 m², accessible independently from the ground floor via a second staircase, perfect for a project of independent apartments, offices, or a professional cabinet. This space remains to be developed according to your needs.Additional assets:3-car garageFull basement / fully excavated cellarImmediate proximity to the tram, major roads, schools, and amenitiesThis rare property, with its incomparable charm, offers numerous possibilities: large family house, division into three units, law office, notary’s office, health center, high-end offices…An exceptional hotel, to be personalized according to your life or professional projects.This description has been automatically translated from French.

NORTH - ROUBAIX Located in the highly residential Barbieux neighborhood of Roubaix, this beautiful 500 m² property offers a pleasant, dynamic, and rewarding living environment. Situated across from Barbieux Park, it enjoys a prime location in the heart of the Lille metropolitan area, in close proximity to urban amenities (metro, tram), the city center, and major access routes. Currently intended for a mixed-use development combining offices and premium residential units, this former mansion—recently renovated and in perfect condition—is divided into several distinct spaces. The mezzanine and second floors house four comfortable, bright apartments, comprising two studios intended for premium student rentals (EDHEC Business School campus is a 15-minute walk away) and two one-bedroom units ideally suited for short-term Airbnb rentals. These four fully self-contained units feature separate entrances and a dedicated service staircase. Blending old-world charm with contemporary interior design, the ground floor and first floor are occupied by spacious, airy office spaces, arranged as functional open-plan areas opening onto the vast, tree-lined garden of nearly 800 m². The monumental staircase connecting the two floors is adorned with a massive Art Deco stained-glass window created by the Lille-based master glassmaker Largillier. An 85-square-meter basement and a 129-square-meter garage provide optimal storage and parking space. Individual gas heating ensures optimal thermal comfort. Currently operated, due to its features and location, as a rental property for office and residential use (generating €81,600 in annual net rental income), it could very easily be restored to its original purpose as a large, luxury family home. Energy class: C Climate class: C Estimated annual energy costs for standard use: between €2,320 and €3,160 per year. Average energy prices indexed for the years 2021, 2022, and 2023. Information on the risks to which this property is exposed is available on the Géorisques website: www.georisques.gouv.fr

A property complex offering approximately 500 m² of living space. This unique property currently houses high-end offices, ancillary spaces, private parking spaces and four residential units generating additional rental income. The complex offers a layout that is both functional and flexible, allowing for a variety of uses depending on requirements and future plans. A second, separate staircase provides access to the apartments, thereby optimising circulation and the independence of the various spaces. Built on a plot of approximately 1,100 m², the property benefits from a remarkable, enclosed garden with mature trees and an ideal aspect, offering a lush, unspoilt setting in the heart of a sought-after urban environment. The property stands out for its remarkable architecture and the signature of a renowned architect behind its design. A complete renovation, completed in 2020, has highlighted the original features and architectural character of the site, whilst incorporating high-end finishes and the contemporary comfort expected today. With its generous floor space, versatility and strategic location, this property is equally suited to use as a primary residence, as a company headquarters or representative office, or as a high-quality investment property offering rental income. Finally, the property enjoys a prime location in the immediate vicinity of the Grand Boulevard, Barbieux Park, the Victor Provo Hospital, shops and transport links (underground and tram), further enhancing its appeal to both users and investors.

Set in a quiet, private residential area within a secure estate, this architect-designed house of approximately 280 m² stands out for its Wattel-style architecture, its generous proportions and its virtually single-storey layout. On the ground floor, the entrance opens onto a beautiful, dual-aspect reception area divided into several spaces: a living room largely facing the swimming pool and terrace, a dining area extending from the kitchen, and a lower-level, more intimate sitting room. The kitchen, which is both separate and open to the reception areas, is fully fitted and features a breakfast nook. A bedroom, which could also be converted into an office, overlooks the lounge and adds to the originality of the layout. The house is organised into two wings. The first houses a very large bedroom with a washbasin, a linen room/laundry room/boiler room, as well as access to a cellar comprising two rooms and the crawl space. The second wing is dedicated to the sleeping quarters and comprises a master bedroom with a walk-in wardrobe and en-suite bathroom, two further bedrooms, a bathroom, and a fourth bedroom with its own en-suite bathroom. Ample bespoke storage space completes the property. The living areas enjoy unobstructed views of the gardens, as the house is flanked on both sides by landscaped and wooded areas. On the south side, the garden features several terraces and a swimming pool, whilst on the north side, a vast lawned garden adds depth and perspective. A carport providing parking for two vehicles, complete with storage space, rounds off the property. An architect-designed house with a unique layout, where the spaces, the views of the gardens and the outdoor areas flow naturally around the house and its swimming pool.

Mont-Saint-Éloi at the heart of the historic village. If you are a lover of wide open spaces, tranquility, and wish to live with your horses running in the parks and their enclosure, this property is made for you! Debuisson Immobilier presents, exclusively, the former farm of the Abbey of the village, completely renovated and offering 595 m2 of living space. Built in the early 12th century, this property overlooks a 34,000 m2 wooded park enclosed by walls, ideal for recharging your batteries. You will discover a majestic entrance hall with its imposing staircase, a modern kitchen overlooking the veranda area that dominates the surrounding countryside, and the living-dining area of 81 m2 offers an antique fireplace. The master bedroom on the garden level with its bathroom and dressing room overlooks the countryside, along with an adjoining children's room and a large office that can be isolated from the main house. On the first floor: you will find a vast landing, 4 bedrooms, a bathroom, an insulated and converted attic, and a gym above the office. You will also benefit from a barn to park your 5 cars, vaulted cellars arranged for your wine tasting evenings, and another barn; the land is sheltered from prying eyes, whether you are horse riders or passionate gardeners, everyone will find their happiness. Finally, you will discover sumptuous ruins, rooms, and a cellar from 1858, bordering a sublime swimming pool area with a jacuzzi and summer kitchen overlooking a French garden. Information about the risks to which this property is exposed is available on the Géorisques website: www.georisques.gouv.frThis description has been automatically translated from French.