Cell631-291-0340
to
 
 
 
Search Search
» Property Criteria
» Features
  •  
» Display Tools
Search

2332  properties match your search;

2310 with Multiple photos ;  2332 with Virtual Tour ;  149 with Videos

Save Search
Showing 1621 - 1630 of 2332 results| view:  results per page« first|...|161|162|163|164|...|last »
  • The Rose at Great Neck. Now finished, this brand new building consists of 40-New Luxury Condominiums on the North Shore of Long Island, located in the Village of Great Neck Estates. This new condo is a two bedroom and two bath on the second floor, approximately 1, 133 sqft, includes private laundry in the unit, an open floor plan and large windows bringing in natural light. The brand new mid-rise building offers many amenities including virtual doorman services, welcome lobby, business lounge with tv plus a gym fitness center. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Very special full on golf simulator coming soon to the building. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a Winter bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball and handball courts. The Rose was creatively designed by Mojo Stumer architects with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Short trip to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary. Welcome home. 30
    218 Middle Neck Rd Unit 205 Great Neck, NY 11021
    $1,236,500
    2 Bedrooms 2 Full Baths Sq. Ft. 1133.00:#
    Condo For Sale ML# 3569427
    The Rose at Great Neck. Now finished, this brand new building consists of 40-New Luxury Condominiums on the North Shore of Long Island, located in the Village of Great Neck Estates. This new condo is a two bedroom and two bath on the second floor, approximately 1, 133 sqft, includes private laundry in the unit, an open floor plan and large windows bringing in natural light. The brand new mid-rise building offers many amenities including virtual doorman services, welcome lobby, business lounge with tv plus a gym fitness center. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Very special full on golf simulator coming soon to the building. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a Winter bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball and handball courts. The Rose was creatively designed by Mojo Stumer architects with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Short trip to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary. Welcome home.
    Presented By: Compass Greater NY LLC  516-517-4751
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Discover the perfect Hamptons retreat in this beautifully maintained three bedroom, two bathroom home.The spacious living room features a cozy fireplace, ideal for relaxing on cooler evenings, while the open floor plan offers ample space for entertaining all year round. Step outside into your private backyard oasis, complete with a heated pool and spa, both equipped with a saltwater system for easy maintenance and a luxurious swimming experience. Whether you’re taking a dip in the pool, soaking in the spa, or lounging poolside, this home is designed for ultimate relaxation. Located minutes from pristine beaches, charming shops, and the best of East End dining, this property combines the convenience of Hampton Bays living with a private, resort-style feel. Don’t miss out on this gem-perfect for year-round living or as a summer getaway!, Additional information: Appearance:Excellent, Separate Hotwater Heater:Y 23
    19 Oceanview Rd Hampton Bays, NY 11946
    $1,245,000
    3 Bedrooms 2 Full Baths Sq. Ft. 1349.00:#
    Single Family For Sale ML# 3581961
    Discover the perfect Hamptons retreat in this beautifully maintained three bedroom, two bathroom home.The spacious living room features a cozy fireplace, ideal for relaxing on cooler evenings, while the open floor plan offers ample space for entertaining all year round. Step outside into your private backyard oasis, complete with a heated pool and spa, both equipped with a saltwater system for easy maintenance and a luxurious swimming experience. Whether you’re taking a dip in the pool, soaking in the spa, or lounging poolside, this home is designed for ultimate relaxation. Located minutes from pristine beaches, charming shops, and the best of East End dining, this property combines the convenience of Hampton Bays living with a private, resort-style feel. Don’t miss out on this gem-perfect for year-round living or as a summer getaway!, Additional information: Appearance:Excellent, Separate Hotwater Heater:Y
    Presented By: Douglas Elliman Real Estate  631-723-2721
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Experience Historic Charm and Timeless living. Famous Little Cottage Circa 1770 built by Morris Bartow who fought under General George Washington, from this Revolutionary Colonial. OLD MEETS NEW, This home invites you to embrace a lifestyle where the past enriches the present. Original chestnut and red oak beams, hand picked floor boards up to 18 inches. Step into complete thoughtful upgrades, and restoration to modern conveniences, without compromise of character that defines the Revolutionary-era roots. All new appliances, electric, plumbing, Marvin windows, cesspools, heat and cooling systems, state of the art quality. Newly painted, impressive in scale, design and architecture unparalleled in luxurious upgrades. Newport brass fixtures, natural gas Wolf stove, Kitchen Aid appliances, french farm sink, Bryant/ Trane / Burnham forced air systems, 4 fireplaces. Redefine your expectations in a royal Primary with En suite. Private tumble marble shower, claw foot bathtub, double vanity with copper hammered sinks, exposed Red oak custom hand picked beams with open cathedral ceilings, walk in closet and stately fireplace. Downstairs large entertainment area, laundry and private wine cellar; clean and fresh immaculate with original Chestnut posts, new washer/dryer. Private park like yard, fire pit, shed and Blue stone patios. Room for Mom, Artist or home business here. Gutter wells, WI-FI, TV Cable, sprinkler system all here. A living piece of History embraces a lifestyle of roots in heritage and grace. Where the past enriches the present. Every detail tells a story offering a unique living experience that honors its 18th century origins while providing comfort for today. This one of a kind hard to find residence stands as an irreplaceable piece of history and art embodying a way of life that is cherished and admired. Historic famous little cottage 1770 home with all the new modern amenities a stones throw away from Northport village, marina, beaches, LIRR and Harborfield schools., Additional information: Interior Features:Guest Quarters, Marble Bath, Separate Hotwater Heater:Y 36
    71 Arbutus Rd Greenlawn, NY 11740
    $1,248,000
    3 Bedrooms 2 Full Baths 1 Half Bath
    Single Family For Sale ML# 3590570
    Experience Historic Charm and Timeless living. Famous Little Cottage Circa 1770 built by Morris Bartow who fought under General George Washington, from this Revolutionary Colonial. OLD MEETS NEW, This home invites you to embrace a lifestyle where the past enriches the present. Original chestnut and red oak beams, hand picked floor boards up to 18 inches. Step into complete thoughtful upgrades, and restoration to modern conveniences, without compromise of character that defines the Revolutionary-era roots. All new appliances, electric, plumbing, Marvin windows, cesspools, heat and cooling systems, state of the art quality. Newly painted, impressive in scale, design and architecture unparalleled in luxurious upgrades. Newport brass fixtures, natural gas Wolf stove, Kitchen Aid appliances, french farm sink, Bryant/ Trane / Burnham forced air systems, 4 fireplaces. Redefine your expectations in a royal Primary with En suite. Private tumble marble shower, claw foot bathtub, double vanity with copper hammered sinks, exposed Red oak custom hand picked beams with open cathedral ceilings, walk in closet and stately fireplace. Downstairs large entertainment area, laundry and private wine cellar; clean and fresh immaculate with original Chestnut posts, new washer/dryer. Private park like yard, fire pit, shed and Blue stone patios. Room for Mom, Artist or home business here. Gutter wells, WI-FI, TV Cable, sprinkler system all here. A living piece of History embraces a lifestyle of roots in heritage and grace. Where the past enriches the present. Every detail tells a story offering a unique living experience that honors its 18th century origins while providing comfort for today. This one of a kind hard to find residence stands as an irreplaceable piece of history and art embodying a way of life that is cherished and admired. Historic famous little cottage 1770 home with all the new modern amenities a stones throw away from Northport village, marina, beaches, LIRR and Harborfield schools., Additional information: Interior Features:Guest Quarters, Marble Bath, Separate Hotwater Heater:Y
    Presented By: Howard Hanna Coach  631-360-1900
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • This Multi-family home offers a total of 4 bedrooms and 2 bathrooms (2nd & 3rd Fl) plus a complete studio with a full bath (1st Fl) across three separate units. Each unit is designed with a full bathroom, a kitchen, a living room, and a dining area. The living rooms feature hardwood flooring and combination design, while the kitchens are equipped with wooden cabinets. Conveniently located near Federalist Triangle, Cowbird Triangle, and Hull Triangle parks, the property is nestled in Maspeth. The area boasts excellent transit options, including the 7 Flushing Local, 7x, Long Beach, Hempstead, and Babylon rail lines, as well as bus routes like the Q67 and Q18. 32
    54-05 65th Place Maspeth, NY 11378
    $1,248,888
    4 Bedrooms 3 Full Baths
    Misc For Sale ML# 804184
    This Multi-family home offers a total of 4 bedrooms and 2 bathrooms (2nd & 3rd Fl) plus a complete studio with a full bath (1st Fl) across three separate units. Each unit is designed with a full bathroom, a kitchen, a living room, and a dining area. The living rooms feature hardwood flooring and combination design, while the kitchens are equipped with wooden cabinets. Conveniently located near Federalist Triangle, Cowbird Triangle, and Hull Triangle parks, the property is nestled in Maspeth. The area boasts excellent transit options, including the 7 Flushing Local, 7x, Long Beach, Hempstead, and Babylon rail lines, as well as bus routes like the Q67 and Q18.
    Presented By: EXP Realty  888-276-0630
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Welcome to a renovated spacious 7-bedroom, 5.5-bath fixer-upper in the heart of Hollis, brimming with character and potential. This single-family home boasts a charming layout, providing the perfect foundation for your dream residence. The main level offers enclosed veranda, a generous living room, kitchen with a formal dining room, a family room and a full bath. On the second floor, the home includes four large bedrooms with unique charm, and 1.5 baths. The big attic has 3 bedroom and a full bath. There is a full fin. walkout basement with utility room, family room, bathroom. The property includes a detached garage and a long private driveway, providing ample parking options. The oversized lot invites gardening, outdoor activities and gatherings. This home is a canvas for your vision and offers an opportunity to create a personalized oasis in Hollis. Embrace the potential and turn this into a unique and charming haven.********Proof of Funds & preapproval letter are preferred for showing, please******.....Video link: https://player.vimeo.com/video/1042557902?badge=0&autopause=0&player_id=0&app_id=58479 38
    9920 196th Street Hollis, NY 11423
    $1,249,000
    7 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 2832.00:# Square Feet
    Single Family For Sale NEW ML# 807081
    Welcome to a renovated spacious 7-bedroom, 5.5-bath fixer-upper in the heart of Hollis, brimming with character and potential. This single-family home boasts a charming layout, providing the perfect foundation for your dream residence. The main level offers enclosed veranda, a generous living room, kitchen with a formal dining room, a family room and a full bath. On the second floor, the home includes four large bedrooms with unique charm, and 1.5 baths. The big attic has 3 bedroom and a full bath. There is a full fin. walkout basement with utility room, family room, bathroom. The property includes a detached garage and a long private driveway, providing ample parking options. The oversized lot invites gardening, outdoor activities and gatherings. This home is a canvas for your vision and offers an opportunity to create a personalized oasis in Hollis. Embrace the potential and turn this into a unique and charming haven.********Proof of Funds & preapproval letter are preferred for showing, please******.....Video link: https://player.vimeo.com/video/1042557902?badge=0&autopause=0&player_id=0&app_id=58479
    Presented By: Wagner & Kelly Inc  718-429-4457
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Welcome to 32 Blanche, Plainview NY, a modern haven built in 2011, offering a delightful blend of comfort, style, and convenience. This four-bedroom, three-bathroom home is a testament to quality craftsmanship, featuring colonial hardwood floors and wood-look tile floors, exuding an air of sophistication and warmth. The heart of the home, the kitchen, is equipped with stainless steel appliances and a central island, perfect for preparing your favorite meals. The open layout ensures a seamless flow from the kitchen to the other areas of the house, making it ideal for hosting gatherings or enjoying quiet evenings. 32 Blanche offers proximity to a variety of local amenities. Enjoy the convenience of nearby shopping centers, parks, and recreational facilities. The community is also home to a diverse array of dining options, from cozy cafes to gourmet restaurants. Whether you’re seeking a family home or a place to entertain, this property has something to offer every lifestyle. 36
    32 Blanche Street Plainview, NY 11803
    $1,299,000
    $1,249,000
    4 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 1952.00:# Square Feet
    Single Family For Sale PRICE REDUCED ML# 803997
    Welcome to 32 Blanche, Plainview NY, a modern haven built in 2011, offering a delightful blend of comfort, style, and convenience. This four-bedroom, three-bathroom home is a testament to quality craftsmanship, featuring colonial hardwood floors and wood-look tile floors, exuding an air of sophistication and warmth. The heart of the home, the kitchen, is equipped with stainless steel appliances and a central island, perfect for preparing your favorite meals. The open layout ensures a seamless flow from the kitchen to the other areas of the house, making it ideal for hosting gatherings or enjoying quiet evenings. 32 Blanche offers proximity to a variety of local amenities. Enjoy the convenience of nearby shopping centers, parks, and recreational facilities. The community is also home to a diverse array of dining options, from cozy cafes to gourmet restaurants. Whether you’re seeking a family home or a place to entertain, this property has something to offer every lifestyle.
    Presented By: Douglas Elliman Real Estate  631-543-9400
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Welcome home to this entertainers delight with 4 levels of living space which includes 4 bedrooms, 3.5 bath, 2 fireplaces and a heated salt water pool. The first floor offers an airy floor plan with an entry foyer, living room with a brick fireplace, formal dining room, & eat in kitchen. The upper floor features a primary king size ensuite with a beautifully updated bath, 2 queen size bedrooms and a full updated hallway bathroom. The ground level has a very large den with fireplace, office space, a butlers pantry, updated full bathroom, 4th bedroom perfect for an au pair suite and sliding doors that open to an expansive paver patio and heated salt water pool. Need more space, the finished lower level offers recreation, a laundry suite, full egress door, utilities and more. This property is a must see entertainers delight!, Additional information: Separate Hotwater Heater:yes 29
    76 Buckminster Rd Rockville Centre, NY 11570
    $1,249,000
    4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 3582.00:#
    Single Family For Sale ML# 3589403
    Welcome home to this entertainers delight with 4 levels of living space which includes 4 bedrooms, 3.5 bath, 2 fireplaces and a heated salt water pool. The first floor offers an airy floor plan with an entry foyer, living room with a brick fireplace, formal dining room, & eat in kitchen. The upper floor features a primary king size ensuite with a beautifully updated bath, 2 queen size bedrooms and a full updated hallway bathroom. The ground level has a very large den with fireplace, office space, a butlers pantry, updated full bathroom, 4th bedroom perfect for an au pair suite and sliding doors that open to an expansive paver patio and heated salt water pool. Need more space, the finished lower level offers recreation, a laundry suite, full egress door, utilities and more. This property is a must see entertainers delight!, Additional information: Separate Hotwater Heater:yes
    Presented By: Signature Premier Properties  516-741-4333
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Prime location in Astoria, just two subway stops to Manhatten.2 Family house. First floor is set up as a 4 room, 1 bedroom unit with access to the full basement and private rear patio. Second floor 2 bedrooms, kitchen, full bathroom. Nice big backyard, large rooms, located next to restaurants, shops, entertainment and more. Located near all major highways, trains & bridges. Will be delivered vacant. Great property for living and investors. This house offers the possibility to expand the current footprint (confirm with your architect). Don’t miss this amazing opportunity! 34
    36-44 32nd Street Astoria, NY 11106
    $1,249,000
    3 Bedrooms 2 Full Baths 1 Half Bath
    Misc For Sale ML# 3586289
    Prime location in Astoria, just two subway stops to Manhatten.2 Family house. First floor is set up as a 4 room, 1 bedroom unit with access to the full basement and private rear patio. Second floor 2 bedrooms, kitchen, full bathroom. Nice big backyard, large rooms, located next to restaurants, shops, entertainment and more. Located near all major highways, trains & bridges. Will be delivered vacant. Great property for living and investors. This house offers the possibility to expand the current footprint (confirm with your architect). Don’t miss this amazing opportunity!
    Presented By: EXP Realty  888-276-0630
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • Nestled on a serene and quiet street, this legal 2-family home is an exceptional find for both homeowners and investors. Spanning 2, 000 sq ft, this property offers versatile living options and modern updates throughout. With hardwood floors throughout, the first floor unit features an updated kitchen with contemporary finishes, a cozy living room perfect for relaxation, a spacious bedroom, and a full bathroom. The second floor duplex includes a modern eat-in kitchen with ample counter space, an inviting living room, a comfortable bedroom, a full bathroom, and private laundry. A staircase leads to the third floor, which offers two additional bedrooms and another full bathroom. The basement provides laundry, utilities, and ample storage space. Enjoy outdoor gatherings on the deck out front, ideal for entertaining guests. Conveniently located just 0.3 miles from the LIRR, this home offers easy access to transportation, making it a commuter’s dream. Don’t miss the opportunity to own this versatile and beautifully updated property in a prime location., Additional information: Appearance:Diamond 28
    242-16 Pine Street Douglaston, NY 11363
    $1,249,000
    4 Bedrooms 3 Full Baths Sq. Ft. 1805.00:#
    Single Family For Sale ML# 3578334
    Nestled on a serene and quiet street, this legal 2-family home is an exceptional find for both homeowners and investors. Spanning 2, 000 sq ft, this property offers versatile living options and modern updates throughout. With hardwood floors throughout, the first floor unit features an updated kitchen with contemporary finishes, a cozy living room perfect for relaxation, a spacious bedroom, and a full bathroom. The second floor duplex includes a modern eat-in kitchen with ample counter space, an inviting living room, a comfortable bedroom, a full bathroom, and private laundry. A staircase leads to the third floor, which offers two additional bedrooms and another full bathroom. The basement provides laundry, utilities, and ample storage space. Enjoy outdoor gatherings on the deck out front, ideal for entertaining guests. Conveniently located just 0.3 miles from the LIRR, this home offers easy access to transportation, making it a commuter’s dream. Don’t miss the opportunity to own this versatile and beautifully updated property in a prime location., Additional information: Appearance:Diamond
    Presented By: Compass Greater NY LLC  516-517-4751
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
  • 3 LOTS LEFT! THE HAMPTON (2, 024 SF): 3bdrm-2.5ba Ranch. Features include an open floor plan with vaulted ceilings throughout for perfect first floor living. The full basement with outside entrance offers an addt’l -2, 000 SF of space. Sycamore Estates is an 18-home new development consisting of 3 privately sidewalked cul-de-sacs conveniently located 5 minutes to the LIE and 9 minutes to the LIRR. Move walls, raise ceilings, design bathrooms, add extensions to your heart’s content, fully customizable. We will consult you through the design process in order to build your dream home up to -6, 000 SF on lots up to half acre+. Pre-designed models are all available, versatile and easily modifiable to serve your needs and lifestyle. Following steps include a buyer consultation to design your dream home. Construction fees subject to change: Water Tap($4, 100), Utilities($1, 100), Gas(free, where applicable), Survey($1, 800), Transfer Tax (standard). Pricing assumes construction financing. Pricing, tax estimates and plans are subject to change and market conditions. Utilities will be subject to site selection. See attachments for specs. Taxes are estimated by Smithtown Assessor., Additional information: Appearance:New Const., Separate Hotwater Heater:No 23
    Lot 18-A Hampton Sycamore Estates Nesconset, NY 11767
    $1,250,000
    3 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 2024.00:# Square Feet
    Single Family For Sale NEW ML# 806967
    3 LOTS LEFT! THE HAMPTON (2, 024 SF): 3bdrm-2.5ba Ranch. Features include an open floor plan with vaulted ceilings throughout for perfect first floor living. The full basement with outside entrance offers an addt’l -2, 000 SF of space. Sycamore Estates is an 18-home new development consisting of 3 privately sidewalked cul-de-sacs conveniently located 5 minutes to the LIE and 9 minutes to the LIRR. Move walls, raise ceilings, design bathrooms, add extensions to your heart’s content, fully customizable. We will consult you through the design process in order to build your dream home up to -6, 000 SF on lots up to half acre+. Pre-designed models are all available, versatile and easily modifiable to serve your needs and lifestyle. Following steps include a buyer consultation to design your dream home. Construction fees subject to change: Water Tap($4, 100), Utilities($1, 100), Gas(free, where applicable), Survey($1, 800), Transfer Tax (standard). Pricing assumes construction financing. Pricing, tax estimates and plans are subject to change and market conditions. Utilities will be subject to site selection. See attachments for specs. Taxes are estimated by Smithtown Assessor., Additional information: Appearance:New Const., Separate Hotwater Heater:No
    Presented By: Realty Connect USA L I Inc  631-881-5160
    Call Today: 631-929-8400, 631-291-0340, or  Email: Kelly Redican
Showing 1621 - 1630 of 2332 results| view:  results per page« first|...|161|162|163|164|...|last »
OneKey™ MLS The data relating to real estate for sale on this web site comes in part from the OneKey™ MLS. Real Estate listings held by brokerage firms other than Realty Connnect USA - Kelly Redican are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
Kelly Redican
Kelly Redican
Licensed Real Estate Salesperson Cell: 631-291-0340
Connect With Me

Questions? Just Ask!

 Submit
Kelly Redican Licensed Real Estate Salesperson
Office: 631-929-8400 Cell: 631-291-0340 6324 Route 25A Suite B, Wading River, NY, 11792
Connect With Me
Admin Login | DMCA Notice
powered by www.erealtymedia.com