Flushing, Queens | Modern 3500 sqft Single Family
$2,790,000
Located in desirable Northern Flushing, this custom-built luxury residence offers rare scale, modern construction and exceptional curb appeal in an area known for classic homes. Featuring a striking symmetrical brick facade, three balconies and professionally landscaped grounds. The first floor offers a grand living room, chef's kitchen with formal dining area, a first-floor ensuite bedroom and an additional half bath, ideal for guests, live-in help or multigenerational living. The second floor includes a spacious primary suite, an additional ensuite bedroom, two standard bedrooms with a shared full bathroom, and an approx. 200 SF lounge. Additional highlights include an approx. 1,300 SF finished attic with hardwood floors and a 10-foot ceiling finished basement with windows and a full bathroom, ideal for home theater, gym or recreation. Enjoy an oversized patio designed for outdoor dining and lounge living. Imported finishes throughout. Prime Location, 3 Blocks to LIRR Broadway Station, close to Northern Blvd, close to bus stops Q12,Q16,Q28. Walking distance to Bowne Park, schools, shopping, restaurants and supermarkets
​Flushing, Queens | 2-Bedroom Condo – Latimer Place #2F
$550,000
2-bed/2-bath condo, 644 SF + 202 SF balcony. Hardwood, elevator, laundry. Ian Lew 917-365-7534
Flushing, Queens | 2-Bedroom Condo – Latimer Place #2B
$539,000
2-bed/2-bath, ~660 SF, south-facing, park views, terrace, W/D each floor. Ian Lew 917-365-7534
Flushing, Queens | 2-Bedroom Condo – Latimer Place #2H
$550,000
Larger 2-bed/2-bath condo, ~804 SF, near 7 train. Washer/dryer each floor. Ian Lew 917-365-7534
Flushing, Queens | Office Condo Units – Latimer Place
$504,600 - $790,200
Office condos, 100% leased. Building 47,256 SF, built 2017. $646-$650/SF. Ian Lew 917-365-7534
Flushing, Queens | Medical Office – Skyview Wellness at Skyview Parc
$1.95M For Sale | $9,800 For Lease
Medical office ~2,000 SF at Skyview Parc. Lease $9,800, Sale $1.95M. Ian Lew 917-365-7534 Confirm permitted use, zoning and licensing with landlord/authorities before signing.
Chinese Takeout Restaurant – Business for Sale
$50,000
Chinese takeout restaurant. Key money $50,000; rent $3,500/mo; CAM 8%. Ian Lew 917-365-7534 New 10-year lease available; 3 months' security + first month at signing.
Flushing, Queens | Modern 1-Bedroom Condo – Prime Location
$524,900
Modern Affordable Luxury | Cherry Plaza Condo – Brand-New Residence in Prime Flushing Location
Located just steps from Flushing–Main Street subway station and the Long Island Rail Road (Flushing–Main Street Station), and surrounded by supermarkets and daily conveniences, this home offers true urban comfort and connectivity.
Welcome to Cherry Plaza Condo, a brand-new brick building offering modern, affordable luxury living. The residence features high ceilings, hardwood floors, and a thoughtfully designed layout for quality, comfortable living.
The building is constructed with a reinforced concrete two-way flat plate structure, providing excellent overall integrity, durability, and superior sound insulation.
Residents enjoy a surveillance security system and video intercom system for added safety and peace of mind.
The kitchen and bathroom are finished with high-quality tiles and engineered quartz, paired with European-style cabinetry and brand-name appliances, creating a warm, elegant, and upscale atmosphere throughout the home.
Brand-new split-system A/C units are installed in both the living room and bedroom. This unit also includes a private outdoor balcony of approximately 40 square feet.
Building amenities include:
-
Elegant first-floor lobby
-
13 on-site parking spaces available for purchase
-
Basement laundry room
Perfect for self-living or investment, this home combines modern design, premium construction, and one of the most convenient locations in Flushing.
Oakland Gardens, Queens | 2-Bedroom Co-op – Bright & Convenient Living
$350,000
Renovated, mint-condition 2-bedroom lower-level co-op in the desirable neighborhood ofBayside, Queens.
This charming and well-maintained home features hardwood floors throughout, a spacious living room, and a bright, well-kept eat-in kitchen (EIK). The unit also offers an in-unit washer, ample closet space, and a highly functional layout ideal for comfortable everyday living.
Conveniently located close to shopping, dining, parks, and public transportation, with easy access to the Q88 and Q27 buses, as well as express buses QM5, QM8, and QM35 toNew York City.
Parking sticker available with garage parking possibility. Enjoy a perfect blend of comfort, convenience, and a well-established community, along with access to numerous building amenities.
Woodhaven | 2-Family Home – Great Investment Opportunity
$999,000
This two-story residence offers a generous 1400 sq. ft. of living space, thoughtfully divided between two 700 sq. ft. floors. The home boasts 4 bedrooms, including a spacious 170 sq. ft. primary bedroom, and 2 full bathrooms. The layout includes two kitchens and two living rooms, providing versatile living arrangements.
Hardwood floors feature prominently in several rooms, adding warmth and elegance to the space. Ceiling fans in bedrooms offer comfort and improved air circulation. The bathrooms are equipped with standard fixtures, including shower/tub combinations and windows for natural ventilation.
The kitchens showcase practical designs with tiled flooring, built-in appliances, and ample cabinet space. Living areas are bright and airy, with large windows allowing natural light to flood the rooms. A central staircase connects the two floors, ensuring easy navigation throughout the home.
The overall ambiance is one of simplicity and functionality, with neutral color schemes that allow for personalization. This multi-level home provides a comfortable living environment suitable for families or those seeking extra space for work or hobbies.
ComeOpenHouse.com
Welcome to ComeOpenHouse.com
NYC’s One-Stop Real Estate & Business Marketing Platform
ComeOpenHouse.com – All-in-One Real Estate Marketing Platform
ComeOpenHouse.com is a comprehensive marketing and promotion platform designed to help real estate agents, buyers, sellers, investors, landlords, and business owners succeed in today’s highly competitive New York City market.
We combine online and offline marketing solutions into one simple, powerful system, making it easier for you to promote your listings, open houses, and business — while keeping full control of your clients and leads.
What We Do
We provide a full range of marketing and support services, including:
-
Get real estate listings
Showcase your listings and open houses with direct inquiries sent straight to you. -
Selling listings
Presentation and promotion to help your listing sell. -
EDDM booklet to get clients
Target entire neighborhoods with professionally designed and USPS-delivered marketing campaigns. Starting ASAP, first delivery area Flushing 11354, also Bayside, Little Neck, Great Neck, Elmhurst, Bensonhurst, 86th St, Chinatown, Long Island City and areas in New Jersey. All services are available to everyone. -
Printing for real estate agents
Real estate signs, window decals, flyers, postcards, and business cards. -
Social media management for clients
Build a steady online presence with posts planned and managed for you. -
Matterport and real estate photography
Interior and exterior photos and 3D virtual tours online. -
Call 917-365-7534 to order or book today
Help for everyone - use the contact page or call for any service.
Our Position
We are not a brokerage.
We are not an employer.
We are your marketing partner — providing the tools, exposure, and support you need to grow your business, while you keep full control of your clients, commissions, and relationships.