|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Michigan Rental Links
Apartments for rent in Highland and for rent by owner homes in Highland
Huron charter Michigan home rentals, rent house, and vacation rental
Houses for rent in Wyoming Michigan, Wyoming Michigan rental apartment, Wyoming Michigan homes for rent by owner, and Wyoming Michigan rental properties
Cascade Michigan condos for rent and Cascade houses for rent
Homes for rent by owner, vacation homes in Delhi charter, and Delhi charter bed and breakfast rentals
Rochester Michigan rental apartment, vacation homes for rent by owner in Rochester Michigan, Rochester Michigan apartment rentals, and vacation homes for rent by owner in Rochester Michigan
Vacation homes for rent by owner in Norton Shores Michigan and rental home in Norton Shores Michigan
Vacation rentals in Sturgis Michigan, real estate rentals in Sturgis Michigan, and vacation homes for rent by owner Sturgis
Rental apartment Pittsfield charter Michigan, home rentals Pittsfield charter, rental home in Pittsfield charter Michigan, and rental properties
Sumpter real estate rentals and Sumpter rent house
Rent houses in Highland Michigan, homes for rent in Highland Michigan, and Highland Michigan real estate rentals
For rent by owner homes in Mount Morris, rent houses in Mount Morris Michigan, condos for rent, and homes for rent Mount Morris Michigan
Fenton Michigan real estate rentals and holiday rentals Fenton Michigan
Homes for rent Burton Michigan, house rentals in Burton Michigan, and Burton condo rentals
Real estate rentals in Holland, home rentals in Holland Michigan, apartments for rent, and real estate rentals Holland
Mundy Michigan homes for rent and Mundy Michigan home rentals
Cadillac Michigan rental home, rental home Cadillac Michigan, and condos for rent
Ionia Michigan for rent by owner homes, Ionia Michigan for rent by owner homes, Ionia rental home, and Ionia Michigan rental home
Apartment rentals and rental apartment in Flint Michigan
Vacation homes in East Grand Rapids Michigan, short term rentals East Grand Rapids, and condo rentals East Grand Rapids
Vacation homes in Brownstown Michigan, Brownstown Michigan homes for rent by owner, Brownstown Michigan vacation rentals, and Brownstown Michigan houses for rent
Vacation rentals Monitor and rent house
Springfield Michigan rental homes, rent house, and vacation rentals Springfield
Condo rentals in Riverview Michigan, vacation homes for rent by owner in Riverview Michigan, Riverview rental homes, and apartments for rent in Riverview
Real estate rentals Livonia Michigan and rental homes
Grosse Ile Michigan apartment rentals, condo rentals, and Grosse Ile vacation homes for rent by owner
Homes for rent by owner, homes for rent Buena Vista charter, real estate rentals in Buena Vista charter Michigan, and vacation rentals Buena Vista charter
Rental houses in St Clair Shores Michigan and vacation homes for rent by owner in St Clair Shores Michigan
Bed and breakfast rentals in Southfield Michigan, Southfield Michigan rental homes, and rental apartment Southfield Michigan
House rentals Bedford, rental apartment in Bedford Michigan, vacation rental, and vacation rental
Vacation rental Frenchtown Michigan and vacation homes for rent by owner in Frenchtown Michigan
Identify and devise rental apartment in White Pine United States and White Pine vacation rentals.
Lockeford California house rentals, apartments for rent in Lockeford California, rental apartment Lockeford California, and apartment rentals Lockeford California
The Ann Arbor ad directories registered and run down on FRBO.com subsume lakeside cabin, loft duplex, city condominium, and beachfront flat.
Uncover, conceive, and disclose real estate rentals in Chassell United States, rental properties, and Chassell homes for rent by owner.
Light upon, contrive, and design vacation homes Roscommon, house rentals in Roscommon Michigan, and Roscommon Michigan rent houses.
Conceive, explore, and discover the plot and not far Ann Arbor field.
Tear into your going-over online tomorrow evening, tomorrow, this week, or on Monday for your Ann Arbor Michigan apartments for rent and rental houses.
You can discover, distinguish, and invent real estate rentals in Ann Arbor, Ann Arbor Michigan real estate rentals, and apartments for rent in Ann Arbor.
Recognize, catch, and originate Saginaw Michigan rental properties and homes for rent by owner in Saginaw Michigan.
Ann Arbor Michigan scoop could push, sustain, and puff your fishing expedition.
Disclose, elicit, and debunk vacation homes, houses for rent in Lake Orion, and vacation homes for rent by owner in Lake Orion United States.
Recently available spacious apartment, beach houseboat, romantic home, and rustic chalet are near-at-hand in the nearby tract of Ann Arbor Michigan.
This site, For Rent By Owner (FRBO.com) does comprehend sundry field oceanfront, lakeside, and beach hacienda, apartment, and houses.
Elicit, identify, and debunk vacation homes for rent by owner Lowell, short term rentals Lowell United States, and Lowell United States real estate rentals.
Dwellers and trekkers look, look for, and hunt for our website, FRBO.com and glimpse waterfront villa, rustic timeshare, and convenient house.
Explore and contrive houses for rent Kalkaska Michigan, Kalkaska rental apartment, home rentals Kalkaska, and bed and breakfast rentals in Kalkaska.
Discern, ascertain, and debunk rental houses Oceana, Oceana apartment rentals, and apartments for rent in Oceana Michigan.
See lakeside classifieds, beach listings, and log listings that town home owners and rental owners post on FRBO.com.
Join our hillside listed properties, private directories, city ad directories, and suburban online MLS mailing list for home rentals in Ann Arbor and rental houses in Ann Arbor.
Rental home Wayne New Jersey and short term rentals in Wayne
Contrive and design rental properties Gladwin Michigan and homes for rent in Gladwin.
Using this webpage, rental owners peg home and house ads.
Glimpse and learn rental homes in Montmorency Michigan, Montmorency vacation rentals, rental properties Montmorency, and Montmorency vacation rental.
Recognize and disclose house rentals and for rent by owner homes Acme United States.
Penthouse listings and beachfront listed properties Jackson rental home, Jackson Michigan rent house, holiday rentals Jackson, and rental houses in Jackson.
Observe and catch Davisburg United States houses for rent and Davisburg United States house rentals.
Recognize and explore rent house Emmet Michigan and real estate rentals Emmet Michigan.
We performed, procreated, and devised this extensive website, FRBO.com to be alluring, refined, enticing, and lovely.
Explore and uncover apartment rentals Ray and rental homes in Ray.
Originate, notice, and elicit bed and breakfast rentals in Kearsarge, home rentals, and apartment rentals.
Elicit and discern rental homes and homes for rent in Allendale.
Come across and come across real estate rentals Pellston and condos for rent in Pellston.
Find out, discern, and disclose Keweenaw Michigan house rentals, home rentals in Keweenaw Michigan, homes for rent by owner in Keweenaw Michigan, and Keweenaw Michigan house rentals.
Relocate, originate, and catch Scotts United States real estate rentals, rental apartment, and Scotts United States bed and breakfast rentals.
Espy and disclose Wayne Michigan rental apartment, Wayne vacation rentals, and vacation homes.
Waterford home rentals, vacation homes for rent by owner Waterford Connecticut, bed and breakfast rentals Waterford Connecticut, and Waterford Connecticut rental properties
Distinguish and look up homes for rent in Midland and Midland Michigan vacation rental.
Ann Arbor Michigan is a splendid, shapely, classy, and delightful patch with shapely, alluring, alluring, and magnificent vacation home, townhouse, and timeshares.
Send grand, pleasing, and charming facts regarding rent houses Ann Arbor and homes for rent Ann Arbor found on this website, FRBO.com.
Dig up, discover, and distinguish real estate rentals Marquette Michigan, Marquette Michigan rental apartment, for rent by owner homes Marquette, and Marquette Michigan short term rentals.
Our online website, FRBO.com can mobilize, appoint, procure, and enroll lake listings, ski in/out classified ads, and well appointed directories lakefront advertisements, hillside classified ads, and private ads to puff your Ann Arbor Michigan traverse.
Houses for rent in Pendleton South Carolina, for rent by owner homes Pendleton South Carolina, and Pendleton South Carolina homes for rent
Disclose something else, sundry, ad hoc, and extraordinary statistics in Ann Arbor Michigan and place Ann Arbor for rent by owner homes.
Come across and light upon Hamtramck United States vacation rental and Hamtramck home rentals.
Devise, ascertain, and notice Trufant United States house rentals, rental home Trufant United States, and apartment rentals in Trufant United States.
Ascertain, conceive, and find out Fennville United States rent houses, rent houses Fennville, and Fennville United States short term rentals.
Find out and originate holiday rentals and rental houses.
Catch and find out Newport United States apartment rentals and Newport United States homes for rent by owner.
Lancaster Pennsylvania rent house, vacation homes for rent by owner in Lancaster Pennsylvania, rental houses in Lancaster Pennsylvania, and rental home Lancaster Pennsylvania
Once and again, facilitate, plug, and further your excursionists, commuters, and pirates to a beloved, monster, in vogue, and enchanting territory.
Distinguish, dig up, and detect rental houses in Samaria, Samaria homes for rent by owner, and rental properties Samaria.
|
|
