SELECT properties.*, files.title AS filetitle, files.file AS filename, states.title AS state FROM listing_properties AS properties LEFT JOIN listing_files AS files ON files.listing_property_id = properties.listing_property_id LEFT JOIN listing_states AS states ON states.listing_state_id = properties.listing_state_id WHERE properties.listing_status='active' AND office_id='24113' AND property_value >= '0' AND property_value <= '1000000' GROUP BY listing_property_id ORDER BY listing_date DESC LIMIT 0,12
USA Realty Group | Real estate agency serving Illinois--Short Sales, REO, MLS Listings
USA Realty Group 714 Enterprise dr. Suite 104 Oak Brook IL 60523 Phone: 1-630-786-0373 Toll free 1-866-877-1960 Fax: 1-312-257-3052
USA Realty Group was created by a group of seasoned brokers and agents with 10+ years of experience. We are known as "toughest negotiators in Chicagoland" for our expertise in short sales and superb customer service.
We've been successfully closing hundreds of short sales since their emergence and our closing ratio is near 100%.
Our team always puts customer first. At the same time, we have great relationships with well-reputed banks and lenders.
USA Realty Group uses the latest technology available to process and track short sale and all other real estate transactions. Our laser-sharp accuracy and unsurpassed transparency always keeps sellers and buyers in the know.
We are actively involved in REO's. Also, we work directly with serial investors and rutinely represent buyers' in auctions.
Whether you are looking to sell or buy, USA Realty Group is your best partner ready to help you make wise decisions. While others promise, we deliver! List your property with us and see what USA Realty Group team can do for you!
This may sound as an oxymoron, but according to WSJ, this is a new strategy of developers of exclusive second home resort communities.
By building smaller, more "affordable" houses for the rich, developers are making them a little less exclusive, but this might be just the right thing to do in order to make a sale.
Even in the up-and-down world of real estate, this pitch may sound a little funny: “Affordable housing for the affluent."
It's the strategy developers of high-end vacation homes are devising as home sales slump in major markets across the country and inventories of unsold homes rise. They are building smaller, less expensive houses in resort communities. As a result, from Turks and Caicos in the West Indies to the Colorado Rockies, some vacation communities are getting just a bit less exclusive.
On a private, 1,100-acre island, Turks & Caicos Sporting Club at Ambergris Cay offers members access to white sand beaches, sports fishing, scuba diving and a jet strip. This year DPS Sporting Club Development Co.rolled out an option to build a small house that could limit a buyer’s purchase of house and land to as low as $1.4 million.