to
 
 
 
Search Search
» Property Criteria
» Features
  •  
» Display Tools
Search

25979  properties match your search;

24293 with Multiple photos ;  2534 with Virtual Tour ;  199 with Videos

Save Search
Showing 24601 - 24610 of 25979 results| view:  results per page« first|...|2459|2460|2461|2462|...|last »
  • This c1920 dairy barn has been transformed into an incredible private residence with soaring ceilings and light filled spaces. Set on a bucolic country road just 90m north of NYC, the barn sits on a 6+ acre lot with no neighbors in sight. The landscape is made up of rolling hillside, open fields and deep forest. Stepping inside you’re greeted by a wide, open staircase leading you up to the second floor. The original hay loft has been converted to a giant Great Room with incredible ceiling height, skylights and exposed beams. French doors at the far end open to a beautiful view of wildflower meadows and a woodstove sits in the corner. An amazing space to gather, celebrate, or enjoy the peace and quiet that this property offers. On the first floor you’ll find an open kitchen with Plain English designed cabinetry and beautiful antique cupboards. Soapstone countertops have been paired with unlaquered brass hardware. A woodburning fireplace sits in the corner and the open concept creates another wonderful space to congregate and relax, all anchored by a large central island. In this original section of the barn there are four bedrooms, one ensuite, and one additional full bath. A new wing was added onto the barn in 2022. From the kitchen, one enters a beautiful sunroom, there is a half bath tucked off to the side and a wall of glass leads one down the hallway into what the current owner’s use as a master suite. It is large and light filled with a walk-in closet and full bath tiled in green zelliege. Two sets of french doors lead outside where you’ll find an outdoor shower and a fenced in vegetable garden. Old rustic barns serve as charming lawn ornaments and screen the property creating total seclusion. Around the corner you’ll find Inness, an amazing hotel & restaurant with a spa opening this year. You’re just 10m to Stone Ridge and 20m to Kingston. A private oasis just 1.5h to NYC. 36
    229 Bone Hollow Rd Accord, NY 12404
    $2,875,000
    4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4635.00:#
    Single Family For Sale ML# H6328516
    This c1920 dairy barn has been transformed into an incredible private residence with soaring ceilings and light filled spaces. Set on a bucolic country road just 90m north of NYC, the barn sits on a 6+ acre lot with no neighbors in sight. The landscape is made up of rolling hillside, open fields and deep forest. Stepping inside you’re greeted by a wide, open staircase leading you up to the second floor. The original hay loft has been converted to a giant Great Room with incredible ceiling height, skylights and exposed beams. French doors at the far end open to a beautiful view of wildflower meadows and a woodstove sits in the corner. An amazing space to gather, celebrate, or enjoy the peace and quiet that this property offers. On the first floor you’ll find an open kitchen with Plain English designed cabinetry and beautiful antique cupboards. Soapstone countertops have been paired with unlaquered brass hardware. A woodburning fireplace sits in the corner and the open concept creates another wonderful space to congregate and relax, all anchored by a large central island. In this original section of the barn there are four bedrooms, one ensuite, and one additional full bath. A new wing was added onto the barn in 2022. From the kitchen, one enters a beautiful sunroom, there is a half bath tucked off to the side and a wall of glass leads one down the hallway into what the current owner’s use as a master suite. It is large and light filled with a walk-in closet and full bath tiled in green zelliege. Two sets of french doors lead outside where you’ll find an outdoor shower and a fenced in vegetable garden. Old rustic barns serve as charming lawn ornaments and screen the property creating total seclusion. Around the corner you’ll find Inness, an amazing hotel & restaurant with a spa opening this year. You’re just 10m to Stone Ridge and 20m to Kingston. A private oasis just 1.5h to NYC.
    Presented By: Four Seasons Sothebys Intl  518-822-0800
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Huge 80x100 lot size magnificent home in the tranquil neighborhood of Tall Oaks of Bayside. Close to 4000 of internal living space (not including basement). Grand foyer entry with large sunlit living room. Granite cathedral ceiling with formal dining room. Custom design granite kitchen with high-end appliances. 2 granite master bedroom suites with Kohler jacuzzi. 2-car garage. Botanical garden-like backyard. Excellent school district with walking distance to highly reputed PS 46 and JHS 74. Near bus #30, #88 and many QM express buses to Manhattan. Can’t miss dream house. 18
    64-16 211th Street Bayside, NY 11364
    $2,880,000
    5 Bedrooms 5 Full Baths Sq. Ft. 3890.00:# Square Feet
    Single Family For Sale NEW ML# 807334
    Huge 80x100 lot size magnificent home in the tranquil neighborhood of Tall Oaks of Bayside. Close to 4000 of internal living space (not including basement). Grand foyer entry with large sunlit living room. Granite cathedral ceiling with formal dining room. Custom design granite kitchen with high-end appliances. 2 granite master bedroom suites with Kohler jacuzzi. 2-car garage. Botanical garden-like backyard. Excellent school district with walking distance to highly reputed PS 46 and JHS 74. Near bus #30, #88 and many QM express buses to Manhattan. Can’t miss dream house.
    Presented By: AAA Young Shuen Realty Inc  718-461-9494
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Magnificent 5-bedroom custom-made colonial attached with a 42 x 111 lot in a beautiful neighborhood of Whitestone. The extra lot can be used to build another luxury home. Cathedral ceiling grand foyer. Top-of-line building materials. Granite center isle gourmet kitchen. Spacious family room with fireplace. Master suite with full jacuzzi bath. Great school district. Walking distance to PS 193. Close to supermarket and shops. Convenient for all and great for big family. 16
    149-20 11th Avenue Whitestone, NY 11357
    $2,880,000
    5 Bedrooms 4 Full Baths Sq. Ft. 3200.00:#
    Single Family For Sale ML# 3584852
    Magnificent 5-bedroom custom-made colonial attached with a 42 x 111 lot in a beautiful neighborhood of Whitestone. The extra lot can be used to build another luxury home. Cathedral ceiling grand foyer. Top-of-line building materials. Granite center isle gourmet kitchen. Spacious family room with fireplace. Master suite with full jacuzzi bath. Great school district. Walking distance to PS 193. Close to supermarket and shops. Convenient for all and great for big family.
    Presented By: AAA Young Shuen Realty Inc  718-461-9494
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Gorgeous new construction home offering luxury living with elegance and breathtaking water & bridge views. This beauty boasts over 3000 sq ft & is built w. attention to detail and impeccable workmanship. There are terraces on both floors w. water & bridge views. The kitchen is equipped w. custom cabinets, quarts countertops, high end appliances plus imported porcelain flrs w. radiant heat. The family room opens up to a spacious rear balcony equipped w. a custom built outdoor kitchen & porcelain floors as well. There is a garage off the full fin spacious recreational basement which is wired for an electric car charging station and the dwy is radiant heat ready. Other features includes Pella windows, Spanish tile roof, Gas fpl, 3 CAC units & much much more. This home is nestled in the quiet residential town of Whitestone however it is still located in NYC offering convenience close proximity to public transportation, major airports, expressways, shops, dining, houses of worship, schools and much more! There is too much to mention! 34
    150-26 Sullivan Drive Whitestone, NY 11357
    $2,880,000
    5 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 3045.00:#
    Single Family For Sale ML# 3563235
    Gorgeous new construction home offering luxury living with elegance and breathtaking water & bridge views. This beauty boasts over 3000 sq ft & is built w. attention to detail and impeccable workmanship. There are terraces on both floors w. water & bridge views. The kitchen is equipped w. custom cabinets, quarts countertops, high end appliances plus imported porcelain flrs w. radiant heat. The family room opens up to a spacious rear balcony equipped w. a custom built outdoor kitchen & porcelain floors as well. There is a garage off the full fin spacious recreational basement which is wired for an electric car charging station and the dwy is radiant heat ready. Other features includes Pella windows, Spanish tile roof, Gas fpl, 3 CAC units & much much more. This home is nestled in the quiet residential town of Whitestone however it is still located in NYC offering convenience close proximity to public transportation, major airports, expressways, shops, dining, houses of worship, schools and much more! There is too much to mention!
    Presented By: United Realty Associates  718-631-1900
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • 4000+ square foot mixed-use building available on Steinway Street in Astoria. Built in 1976 and featuring 3 residential apartments and 1 commercial unit, the subject is built 20 x 90 and also features an attached 2-car garage accessed via common driveway on 28th Ave. Great Astoria location. Upside on the residential rents. fuel $6500, insurance $4000, water $2800, common electric $840. 2
    25-94 Steinway Street Astoria, NY 11103
    $2,880,000
    5 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4020.00:#
    Commercial For Sale ML# 3542270
    4000+ square foot mixed-use building available on Steinway Street in Astoria. Built in 1976 and featuring 3 residential apartments and 1 commercial unit, the subject is built 20 x 90 and also features an attached 2-car garage accessed via common driveway on 28th Ave. Great Astoria location. Upside on the residential rents. fuel $6500, insurance $4000, water $2800, common electric $840.
    Presented By: Landmark International R E LLC  718-898-8300
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Calling All Investors, Developers & End-Users!!! Magnificent 134 Acre Development Site In Eastport For Sale!!! The Property Spans 3 Miles From Old Country Road To Route 27 (Sunrise Hwy.) Near The Speonk LIRR Station & The Francis S. Gabreski Airport!!! The Property Features Great Exposure, Excellent Signage, 2, 800 Parking Spaces, 11 Lots, Strong Zoning, Low Property Taxes, +++!!! Neighbors Include Amazon, Starbucks, 7-Eleven, Dunkin’, King Kullen, Sherwin-Williams, Valero, +++!!! According To The Seller There’s A Potential Yield Of 20-22 Building Lots!!! The Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site / The Next Home For Your Business!!! Taxes: $47, 940.94 Ann. 10
    202-214 Old Country Eastport, NY 11941
    $2,888,000
    Misc For Sale ML# 804808
    Calling All Investors, Developers & End-Users!!! Magnificent 134 Acre Development Site In Eastport For Sale!!! The Property Spans 3 Miles From Old Country Road To Route 27 (Sunrise Hwy.) Near The Speonk LIRR Station & The Francis S. Gabreski Airport!!! The Property Features Great Exposure, Excellent Signage, 2, 800 Parking Spaces, 11 Lots, Strong Zoning, Low Property Taxes, +++!!! Neighbors Include Amazon, Starbucks, 7-Eleven, Dunkin’, King Kullen, Sherwin-Williams, Valero, +++!!! According To The Seller There’s A Potential Yield Of 20-22 Building Lots!!! The Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site / The Next Home For Your Business!!! Taxes: $47, 940.94 Ann.
    Presented By: All Island Estates Realty Corp  516-783-5600
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Stately Luxurious Home Set on a Sprawling 1/2 Acre Park-like Flat Property in the Heart of The Village of Kensington, Providing An Ideal Setting for Both Indoor & Outdoor Entertaining. Wonderful Tiled Entry Foyer Leads to a Beautifully Designed Open Floor Plan. Formal Living Room w/ Cathedral Ceilings, Wood Burning Fireplace & Glass Doors Leads to a Covered Patio Adding to the Sense of Space and Sophistication. Banquet Sized Formal Dining Room & 2 Dens w/ Custom Built -in Wet Bar Overlooking Magnificent Grounds. State of the Art Sky-lit Eat-in Kitchen with High End Appliances. Gorgeous Hardwood Floors & Wainscotting Throughout. Sun-lit Totally Updated Designer Interiors, Home Office & Full Basement. Water Filtration System. Residents Enjoy the Village of Kensington’s Private Police, Pool Club & Access to the Great Neck Park District. Centrally Located Minutes from LIRR & New Grand Central Line, Town & Shopping. EM Baker Elementary & Option Great Neck South/North Middle & High Schools., Additional information: Appearance:DIAMOND, Separate Hotwater Heater:Y 33
    70 Nassau Drive Great Neck, NY 11021
    $2,888,000
    4 Bedrooms 3 Full Baths 1 Half Bath
    Single Family For Sale ML# 3591349
    Stately Luxurious Home Set on a Sprawling 1/2 Acre Park-like Flat Property in the Heart of The Village of Kensington, Providing An Ideal Setting for Both Indoor & Outdoor Entertaining. Wonderful Tiled Entry Foyer Leads to a Beautifully Designed Open Floor Plan. Formal Living Room w/ Cathedral Ceilings, Wood Burning Fireplace & Glass Doors Leads to a Covered Patio Adding to the Sense of Space and Sophistication. Banquet Sized Formal Dining Room & 2 Dens w/ Custom Built -in Wet Bar Overlooking Magnificent Grounds. State of the Art Sky-lit Eat-in Kitchen with High End Appliances. Gorgeous Hardwood Floors & Wainscotting Throughout. Sun-lit Totally Updated Designer Interiors, Home Office & Full Basement. Water Filtration System. Residents Enjoy the Village of Kensington’s Private Police, Pool Club & Access to the Great Neck Park District. Centrally Located Minutes from LIRR & New Grand Central Line, Town & Shopping. EM Baker Elementary & Option Great Neck South/North Middle & High Schools., Additional information: Appearance:DIAMOND, Separate Hotwater Heater:Y
    Presented By: Edna Mashaal Realty LLC  516-504-8884
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Calling All Investors, Developers & End-Users!!! 100% Occupied 12 Family Building Package For Sale!!! The Buildings Feature Excellent Signage, Great Exposure, Strong R7A Zoning, High 10’ Ceilings, Security System, Yard, Fenced Lot, 6 Parking Spaces, 200 Amp Power, All New LED Lighting, A/C In Every Unit, +++!!! The Property Is Located In The Heart Of Elmhurst Just Off Broadway Only Minutes From Queens Center!!! Neighbors Include Apple, TD Bank, Adidas, Costco, Target, 7-Eleven, Dunkin’, Walgreens, Planet fitness, Cold Stone Creamery, Raymour & Flanigan, Mattress Firm, Macy’s, Shack Shack, Dollar Tree, Liberty Tax, McDonald’s, White Castle, Subway, +++!!! As Per The Seller Each Building Has An Additional 5, 000 Sqft. Of Air Rights!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or Make A Nice Addition To Your Portfolio!!! Income: 42-20 82nd St.: Unit 1A: $18, 581.88 Ann. Lease Exp.: 10/31/24 . Unit 1B: $20, 582.76 Ann. Lease Exp.: 10/31/24. Unit 2A: $24, 084.96 Ann. Lease Exp.: 10/31/25. Unit 2B: $22, 520.40 Ann. Lease Exp.: 10/31/25. Unit 3A: $21, 041.40 Ann. Lease Exp.: 3/31/25. Unit 3B: $21, 199.20 Ann. Lease Exp.: 10/31/24. 42-22 82nd St.: Unit 1A: $11, 521.32 Ann. Lease Exp.: 12/31/24. Unit 1B: $14, 265.36 Ann. Lease Exp.: 10/31/25. Unit 2A: $27, 121.56 Ann. Lease Exp.: 12/31/24. Unit 2B: $27, 000 Ann. Unit 3A: $19, 966.68 Ann. Lease Exp.: 10/31/24. Unit 3B: $25, 800 Ann. Lease Exp.: 4/30/24. Total Rental Income: $253, 685.52 Ann. Expenses: Heating: $29, 987 Ann. Insurance: $12, 713.88 Ann. Water & Sewer: $14, 583.18 Ann. Taxes: $49, 376.98 Ann. Total Expenses: $106, 661.04 Ann. Gross Income: $253, 685.52 Ann. Net Operating Income (NOI): $147, 024.48 Ann. , or 27
    42-20+22 82nd Street Elmhurst, NY 11373
    $2,888,000
    Sq. Ft. 10886.00:#
    Misc Commercial ML# 3544942
    Calling All Investors, Developers & End-Users!!! 100% Occupied 12 Family Building Package For Sale!!! The Buildings Feature Excellent Signage, Great Exposure, Strong R7A Zoning, High 10’ Ceilings, Security System, Yard, Fenced Lot, 6 Parking Spaces, 200 Amp Power, All New LED Lighting, A/C In Every Unit, +++!!! The Property Is Located In The Heart Of Elmhurst Just Off Broadway Only Minutes From Queens Center!!! Neighbors Include Apple, TD Bank, Adidas, Costco, Target, 7-Eleven, Dunkin’, Walgreens, Planet fitness, Cold Stone Creamery, Raymour & Flanigan, Mattress Firm, Macy’s, Shack Shack, Dollar Tree, Liberty Tax, McDonald’s, White Castle, Subway, +++!!! As Per The Seller Each Building Has An Additional 5, 000 Sqft. Of Air Rights!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or Make A Nice Addition To Your Portfolio!!! Income: 42-20 82nd St.: Unit 1A: $18, 581.88 Ann. Lease Exp.: 10/31/24 . Unit 1B: $20, 582.76 Ann. Lease Exp.: 10/31/24. Unit 2A: $24, 084.96 Ann. Lease Exp.: 10/31/25. Unit 2B: $22, 520.40 Ann. Lease Exp.: 10/31/25. Unit 3A: $21, 041.40 Ann. Lease Exp.: 3/31/25. Unit 3B: $21, 199.20 Ann. Lease Exp.: 10/31/24. 42-22 82nd St.: Unit 1A: $11, 521.32 Ann. Lease Exp.: 12/31/24. Unit 1B: $14, 265.36 Ann. Lease Exp.: 10/31/25. Unit 2A: $27, 121.56 Ann. Lease Exp.: 12/31/24. Unit 2B: $27, 000 Ann. Unit 3A: $19, 966.68 Ann. Lease Exp.: 10/31/24. Unit 3B: $25, 800 Ann. Lease Exp.: 4/30/24. Total Rental Income: $253, 685.52 Ann. Expenses: Heating: $29, 987 Ann. Insurance: $12, 713.88 Ann. Water & Sewer: $14, 583.18 Ann. Taxes: $49, 376.98 Ann. Total Expenses: $106, 661.04 Ann. Gross Income: $253, 685.52 Ann. Net Operating Income (NOI): $147, 024.48 Ann. , or
    Presented By: All Island Estates Realty Corp  516-783-5600
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Welcome to this newly renovated Class A professional office building located in Tangram Tower in the heart of Flushing. Suite 2A is a corner unit on the 2nd Floor, approximately 2050 square feet with Southeast exposure, large, oversized windows, sunny & bright with a lot of natural light. Fully functional bathroom, sink for hand washing and reception desk area. Easy access with multiple elevator banks in the building. Space is suitable for medical office, health center, library, community service use etc. Tangram Tower office property has a 25 ICAP Tax Abatement. Located conveniently in a major commercial and retail area centered around the intersection of Main Street and Roosevelt Ave. Close to all public transportation, including #7 Subway, LIRR train station, buses, 678 highway, express bus, banks, and shopping center. Must to see! 17
    37-12 Prince Street Unit 2A Flushing, NY 11354
    $2,888,888
    Sq. Ft. 2050.00:#
    Office Commercial ML# 3539042
    Welcome to this newly renovated Class A professional office building located in Tangram Tower in the heart of Flushing. Suite 2A is a corner unit on the 2nd Floor, approximately 2050 square feet with Southeast exposure, large, oversized windows, sunny & bright with a lot of natural light. Fully functional bathroom, sink for hand washing and reception desk area. Easy access with multiple elevator banks in the building. Space is suitable for medical office, health center, library, community service use etc. Tangram Tower office property has a 25 ICAP Tax Abatement. Located conveniently in a major commercial and retail area centered around the intersection of Main Street and Roosevelt Ave. Close to all public transportation, including #7 Subway, LIRR train station, buses, 678 highway, express bus, banks, and shopping center. Must to see!
    Presented By: Douglas Elliman Real Estate  516-637-5618
    Call Today: 347-489-9595, or  Email: Betsy Pollak
  • Welcome to Beechhurst, where timeless elegance meets modern luxury. This magnificent brick colonial home has undergone a complete transformation, boasting the highest quality updates throughout. Upon entering, you’ll be captivated by the intricate custom plaster moldings that adorn the walls, ceilings, and crown. These exquisite details, complemented by beautiful chandeliers, create an ambiance of sophistication and charm. The grand foyer, with its soaring 20-foot ceilings and sweeping bridal staircase, serves as the focal point of this spectacular residence. Entertain guests in style as they gather in the spacious living room, accessible from both the family room and foyer, exuding formality and stately elegance. The heart of the home lies in the meticulously designed eat-in kitchen, featuring inset custom cabinetry, luxurious marble countertops, and top-of-the-line Subzero/Wolf appliances. Whether preparing a casual meal or hosting a grand feast, this culinary space is sure to delight even the most discerning chef. Adjacent to the kitchen, the oversized family room seamlessly connects to the private outdoor living space, complete with a large wood burning fireplace. The family room opens up to bluestone patio and expansive backyard. Here, you’ll find the perfect retreat to unwind, entertain, and create lasting memories with friends. Upstairs, discover four generously sized ensuite bedrooms, each offering a sanctuary of comfort and privacy. Convenience is key with two laundry services, including one conveniently located off the primary bedroom suite. Located in the coveted Beechhurst neighborhood, this exceptional residence offers unparalleled convenience. Enjoy easy access to shopping, dining, major highways, the airport, and the vibrant energy of Manhattan-all just moments from your doorstep. Experience the epitome of luxury living in Beechhurst. 35
    157-03 9th Avenue Beechhurst, NY 11357
    $2,895,000
    4 Bedrooms 4 Full Baths 2 Half Baths Sq. Ft. 4500.00:#
    Single Family For Sale ML# 3575958
    Welcome to Beechhurst, where timeless elegance meets modern luxury. This magnificent brick colonial home has undergone a complete transformation, boasting the highest quality updates throughout. Upon entering, you’ll be captivated by the intricate custom plaster moldings that adorn the walls, ceilings, and crown. These exquisite details, complemented by beautiful chandeliers, create an ambiance of sophistication and charm. The grand foyer, with its soaring 20-foot ceilings and sweeping bridal staircase, serves as the focal point of this spectacular residence. Entertain guests in style as they gather in the spacious living room, accessible from both the family room and foyer, exuding formality and stately elegance. The heart of the home lies in the meticulously designed eat-in kitchen, featuring inset custom cabinetry, luxurious marble countertops, and top-of-the-line Subzero/Wolf appliances. Whether preparing a casual meal or hosting a grand feast, this culinary space is sure to delight even the most discerning chef. Adjacent to the kitchen, the oversized family room seamlessly connects to the private outdoor living space, complete with a large wood burning fireplace. The family room opens up to bluestone patio and expansive backyard. Here, you’ll find the perfect retreat to unwind, entertain, and create lasting memories with friends. Upstairs, discover four generously sized ensuite bedrooms, each offering a sanctuary of comfort and privacy. Convenience is key with two laundry services, including one conveniently located off the primary bedroom suite. Located in the coveted Beechhurst neighborhood, this exceptional residence offers unparalleled convenience. Enjoy easy access to shopping, dining, major highways, the airport, and the vibrant energy of Manhattan-all just moments from your doorstep. Experience the epitome of luxury living in Beechhurst.
    Presented By: BERKSHIRE HATHAWAY  631-824-8484
    Call Today: 347-489-9595, or  Email: Betsy Pollak
Showing 24601 - 24610 of 25979 results| view:  results per page« first|...|2459|2460|2461|2462|...|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 Betsy Pollak are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.

Questions? Just Ask!

 Submit
Phone: 718-886-6800
214-08 41st. Avenue, Bayside, NY 11361
35-36 Union Street, Suite 201, Flushing, NY 11354
(c) 347.489.9595
betsy@baysidenyrealty.com ©2017 Betsy Pollak
Lic. Assoc. Real Estate Broker
sitemap | login | DMCA Notice powered by www.erealtymedia.com