Just Listed! 1 Bates Road Great Neck

Welcome to 1 Bates Road 

Spacious 5 BR 3/Baths. This is a great opportunity to own this beautiful 5 bedroom home. The home is set back from the Street and sits on a spacious 8,580SF lot.
Unique possibility in Great Neck to convert to a two family or have a spacious single family home. Ideal for new construction as well.
The home features a renovated kitchen and spacious living room with fireplace. Renovated bathrooms. Fully finished basement with access to backyard from basement. Detached 4 Car Garage.
Great Neck South Schools- Parkville, Lakeville, South Middle, South High School
Close proximity to – LIRR 25 Minutes to Manhattan.
Lot Size: 8,580SF
Low taxes
Priced to Sell Fast !! Avoid Mansion Tax.

Asking Price:$998,000.00
Shown by appointment only

Listing Info

Licensed Real Estate Broker


MQ Realty
All information should be verified by buyer.


Hot Off The Press

“Done Deals! ” Cesar Guevara of MQ Realty Makes News. SEE  MQ Realty Featured on REAL ESTATE WEEKLY . Ending 2015 with brokering the Sale of a  Manhattan Townhouse on East 82nd Street. Check it out…. Read Full Article


Just SOLD! Upper East Side Townhouse

524 East 82nd Street.jpgMQ Realty Just Sold 524 East 82nd Street NYC townhouse 

NEW! JUST LISTED! W53rd St 1 Bedroom APT For Rent ! Bring your Sunglasses!

new rental listing in midtown

Now thats a great deal! 

Room bedroom HallwayBedroom Bedroom

Exclusive : 360 West 53rd St

This is a great Deal! An apartment in the city with views under $3 grand. Yes its a walk up apartment building. But consider there is no one above you!  The apartment has been recently renovated with super high ceilings, Beautiful wood floors. Great Closet space.  Lovely subway tiled bath. Remote controlled  A/C units . And large windows.  Its also super sunny and bright. The building offers secure entry and Laundry on Site. Professionally Managed Property. Fantastic Location leaving you with so much to do day or night in the city that never sleeps … near Restaurant Row on 9th Ave, Theatre district,Times Square, Carnegie Hall and Close to Columbus Circle , Museums and More!  Access to all trains with in walking distance.    Contact Cesar Guevara for an appointment today! 917-523-4681 or email me at Cguevara@mqrealty.com.

Listing ID

Large 1Br Apartment For Rent 35th Street & Broadway

3114 35th Street 15555_48030 15555_48031

31-14 35th Street Astoria NY

Listing ID 15555

This apartment is a lovely one bedroom apartment in a well kept Pre War Walk up Building. Situated on a lovely Queens Tree Lined Block. The apartment features a large separate windowed Kitchen.  The living room is spacious and bright. The Bedroom is large with closets. Pets are not allowed. The heat and hot water is included in the rent price. The location is superb because of convenience to both the train and subway. You have a choice N,Q Trains or R,M Trains. Also Many shops and markets along Broadway, and retail shops on Steinway Streets. Enjoy the outdoor cafes, restaurants and bars near by on 30th Ave. You are Close to Manhattan, just a few minutes away by Train. Call Today for a great deal! Or contact us at info@mqrealty.com or cguevara@mqrealty.com. Rent: 1700/Month

Just Listed! Gorgeous SPACE 4Bedroom Duplex with Terrace in Astoria Queens

DSC00361 DSC00363 DSC00364 DSC00365 DSC00366 DSC00369

For Rent By MQ Realty 

This apartment is situated on a quiet Residential Block in Astoria Queens! Live in a spacious  4 bedroom Duplex Apartment with  2 Full Baths.  2 Full FLOORS. Features a Spacious Eat in Kitchen with Large Windows. Large Rooms. Great Natural Light through out the house.  Beautiful honey stained wood floors. The Apartment also comes with a large terrace and additional storage if needed. Located Near Astoria Park and transportation. Available For January 15th Move in. Contact Cesar Guevara Today!

Email: cguevara@mqrealty.com for appointments

Rent is $4000/Month

For more information on this listing you may check out our website Listing ID 15425.

HELLS KITCHEN Renovated 1BR Gorgeous











Hells Kitchen NYC 1BR apartment for rent


415 West 44th Street NY. Rent this Beauty in Hells Kitchen.  Midtown West NYC. The sun-filled apartment has been renovated and features high ceilings.  Separate kitchen with stainless steel appliances.  One full bath. Heat and Hot water are included in the rent. Exact photos are shown. Great location, near the theatre district and Times Square. Close to Trains.

Rent: $2,300/ Month

Listing ID

Call or Text Cesar Guevara today 917-523-4681. Licensed Real Estate Broker, MQ Realty LLC


Huge Long Island City Apt For Rent

Fantastic DEAL! Sprawling 3 bedroom apartment for rent in Long Island City. The apartment features large rooms with high ceilings.  There is a separate very large windowed Kitchen with full sized appliances including dishwasher and microwave. You have several windows allowing great natural light in the apartment.  The Living /dining room is enormous. The bedrooms are all spacious with large closets in all. Fantastic deal and priced well below market.  Small pet considered. You are 2 blocks from Trains  7 E R N M. Easy commute to Manhattan. Must see to appreciate. Call or text LREB Cesar Guevara today. 917-523-4681. Rent $2,995/Month

Listing ID 

Elegant Space 3BR Apartment for Rent Flushing NY

DSCN2737 (1)DSCN2735 (1)DSCN2732 (1)DSCN2731DSCN2726DSCN2727


Located in Flushing, Queens. Move right in to this elegant and spacious three bedroom 1.5 baths apartment. The apartment has brand new renovations including a new kitchen and new bathrooms.  Quality finishes through out. Beautiful and spacious rooms.  Balcony off the dining area. Great closet space and natural light.   Washer Dryer in the unit.  Must see to appreciate. Close proximity to Main St. Flushing Meadows Park, As well as NY Presbyterian Hospital.   Contact us to Call it home.

Listing ID

Call Cesar Guevara today 917-523-4681.


VIEWS! NICE 2BR Apt for Rent Astoria, Queens

37-02 31st Avenue, Astoria NY 

Recently Renovated 2 bedroom apartment for rent. The apartment has a small kitchenette with granite counter and its open to the living room. There are two bedrooms similar in size. Beautiful wood floors throughout the space and High Ceilings.  One full nicely tiled bathroom. The apartment has been recently gut-renovated. No Pets allowed. The apartment is on the 3rd floor with great light and views. It includes heat and hot water.  Its located in a great location near the 30th Ave or Broadway Station on the N&Q Trains. Also convenient to shopping, restaurants, and cafes. Relatively an easy commute to Manhattan.  For More information call or text Cesar Guevara 917-523-4681.

Cesar Guevara

Rent $2050/ Month

Call or Text Cesar Guevara 917-523-4681

Just LISTED! 3BR Inwood Apt for Rent

Fantastic Three Bedroom apartment for rent in INWOOD NYC.

Welcome to W204th St 3BR Apartment! Actual photos shown. Beautiful renovations throughout. The apartment features Exposed Brick walls, High Ceilings, Beautiful wood flooring. Good Closet space. Large windowed Galley Kitchen. The kitchen is equipped with new Stainless Steel appliances including a dishwasher. One Full Bath. Separate Living Room. Heat and Hot water is included in the rent.  Great Natural light since the apartment is on the top floor. Small Pet considered on case by case basis. Located Near A Trains on W207th St. Near the Inwood Park.  Must see! Call or  TEXT Cesar Guevara today. Available Now.

Rent $ 2,400.00/Month.

Call or Text  Listing Broker Cesar Guevara today! 917-523-4681

Listing ID

NYC Views from Your Apartment


35th Street Astoria Queens

HOT DEAL!  Now Available is a Lovely TOP Floor One Bedroom Apartment for rent in Astoria Broadway Area. This photo is taken from the apt. Unobstructed Partial BLUE Sky and NYC in the backdrop. The apartment is in a lovely Pre War Building. Apartment also features a brand new bathroom. Good Closet space and a separate windowed Kitchen. The Bedroom offers two closets. There are wood floors through out the apartment. You are steps from notable cafes, bars, restaurants and shops. Convenient to Manhattan via NQ Trains. Enjoy a Short Commute to the city !


Text or Call Cesar Guevara 917-523-4681 today! Cguevara@mqrealty.com for more info