|
<%@ 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
Oak Park bed and breakfast rentals and short term rentals in Oak Park
Rent houses Flint, homes for rent by owner, and home rentals in Flint Michigan
Rental houses, Monroe charter Michigan house rentals, Monroe charter real estate rentals, and real estate rentals in Monroe charter
Homes for rent by owner Monroe and for rent by owner homes in Monroe Michigan
House rentals Waterford Michigan, Waterford Michigan vacation homes for rent by owner, and vacation homes
Niles Michigan condos for rent, Niles Michigan condo rentals, rental houses Niles Michigan, and short term rentals in Niles Michigan
Rental properties Harrison and rental houses in Harrison Michigan
Rental apartment in Comstock Michigan, rental home in Comstock Michigan, and rental properties in Comstock
Ann Arbor Michigan real estate rentals, house rentals in Ann Arbor Michigan, for rent by owner homes Ann Arbor, and holiday rentals in Ann Arbor
Vacation rental in Kentwood and houses for rent in Kentwood
Antwerp Michigan rental houses, Antwerp real estate rentals, and Antwerp Michigan real estate rentals
Rental homes Ionia Michigan, Ionia Michigan real estate rentals, vacation rentals in Ionia, and Ionia Michigan rental home
Condo rentals Lincoln charter and Lincoln charter Michigan vacation rental
Rental home in Mount Clemens Michigan, rental homes, and Mount Clemens Michigan real estate rentals
Vacation homes Georgetown, Georgetown home rentals, apartments for rent, and condo rentals Georgetown
Rental home and Coldwater Michigan condo rentals
Springfield Michigan rental home, home rentals Springfield, and Springfield Michigan house rentals
Ypsilanti Michigan bed and breakfast rentals, rent houses Ypsilanti Michigan, apartment rentals in Ypsilanti Michigan, and house rentals Ypsilanti
Vacation homes Spring Lake and Spring Lake homes for rent
Apartments for rent in Benton charter, Benton charter Michigan vacation homes, and Benton charter Michigan for rent by owner homes
Rent house Commerce, house rentals in Commerce Michigan, Commerce Michigan apartment rentals, and Commerce Michigan rental home
Rental houses in Grand Blanc Michigan and holiday rentals in Grand Blanc Michigan
Houses for rent in Allendale Michigan, rental apartment in Allendale Michigan, and houses for rent in Allendale Michigan
Owosso vacation rental, rental properties, Owosso Michigan bed and breakfast rentals, and apartments for rent in Owosso Michigan
Invent and explore Ottawa Michigan rental apartment and Ottawa Michigan rental properties.
Ascertain, devise, and find Cheboygan Michigan rental home and Cheboygan Michigan rental houses.
Learn and discover the stretch and immediate West Bloomfield plot.
The West Bloomfield secluded lists of marked properties, romantic ads, and lake ad directories for these patch can be mapped.
Notice, notice, and invent rental apartment Gladwin and Gladwin home rentals.
Penthouse classified advertisements and waterfront classifieds Midland Michigan condo rentals, Midland vacation rental, vacation rentals in Midland, and condo rentals Midland Michigan.
The West Bloomfield Michigan online MLS placed and specified on our website, FRBO.com subsume decadent villa and suburban duplex.
Nearly ready lakefront home, convenient houseboat, waterfront chalet, and rustic hacienda are handy in the not far away principality of West Bloomfield Michigan.
Glimpse, look up, and originate apartments for rent in Union United States, Union bed and breakfast rentals, and vacation homes for rent by owner Union United States.
Notice, glimpse, and espy Wexford Michigan vacation rental, Wexford Michigan holiday rentals, Wexford Michigan vacation homes for rent by owner, and vacation homes Wexford.
We contrived, imagined, and constituted this extensive website, FRBO.com to be comely, lovely, splendid, and lovely.
Invent and find homes for rent by owner and Goodells rental houses.
Union Ohio homes for rent, Union Ohio apartments for rent, rent houses Union, and vacation rentals in Union
Ascertain and move homes for rent by owner in Hillsdale Michigan, rental houses, rental home in Hillsdale Michigan, and condo rentals Hillsdale.
Debunk, elicit, and disclose rental homes Mount Pleasant United States, rental properties in Mount Pleasant United States, and condo rentals in Mount Pleasant.
Invent, invent, and originate Shepherd United States homes for rent, rental houses in Shepherd United States, and apartments for rent in Shepherd United States.
Once in a while, facilitate, assist, and root for your possessors, salesmen, and traveling men to a alluring and lovely locality.
Originate, identify, and uncover vacation homes New Boston United States, New Boston United States vacation rentals, and vacation homes in New Boston United States.
West Bloomfield Michigan is a magnificent, cute, and shapely sector with sightly and bewitching condominium, timeshare, and farmhouses.
Move, find out, and observe Allendale holiday rentals, Allendale United States rent houses, and Allendale United States homes for rent by owner.
Disclose and devise holiday rentals Dundee United States and Dundee United States house rentals.
You can study the city lists of marked properties, lakeside listings, convenient ads, and well appointed advertisements under rental apartment in West Bloomfield and rental properties.
Conceive and originate rent houses in Sanford United States and apartment rentals in Sanford.
|
|
