|
<%@ 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
South Lyon Michigan vacation rentals and for rent by owner homes in South Lyon Michigan
Rental properties in Ecorse Michigan, Ecorse Michigan vacation rental, and short term rentals Ecorse Michigan
Houses for rent Saginaw charter, rent house in Saginaw charter Michigan, Saginaw charter Michigan real estate rentals, and vacation rentals in Saginaw charter Michigan
Rental home in Bay City and rental properties Bay City
Condo rentals Grand Haven, apartments for rent, and Grand Haven Michigan condos for rent
Sterling Heights Michigan rent house, rent house in Sterling Heights Michigan, apartments for rent in Sterling Heights Michigan, and bed and breakfast rentals
Sumpter Michigan houses for rent and Sumpter vacation homes for rent by owner
Byron Michigan for rent by owner homes, house rentals in Byron Michigan, and Byron Michigan apartments for rent
Shelby charter Michigan houses for rent, holiday rentals Shelby charter Michigan, Shelby charter rent houses, and rent houses Shelby charter Michigan
Holiday rentals Delta charter Michigan and vacation homes for rent by owner Delta charter Michigan
Roseville Michigan vacation homes for rent by owner, houses for rent in Roseville Michigan, and vacation rentals Roseville Michigan
Clinton Michigan condos for rent, homes for rent by owner Clinton Michigan, Clinton vacation rentals, and homes for rent Clinton Michigan
Houses for rent Novi Michigan and condo rentals in Novi Michigan
Wixom Michigan rent houses, Wixom rental houses, and Wixom Michigan rental home
Homes for rent by owner, home rentals, rental houses in Allendale Michigan, and Allendale Michigan apartment rentals
House rentals in Grand Blanc Michigan and short term rentals
Vacation homes in Benton Harbor Michigan, apartments for rent Benton Harbor, and Benton Harbor Michigan home rentals
Milford Michigan rental apartment, houses for rent Milford, Milford real estate rentals, and houses for rent Milford Michigan
Holland rent houses and apartment rentals in Holland
Rental home, rental apartment, and for rent by owner homes in Garden City
Apartments for rent in Bloomfield, Bloomfield Michigan rental homes, house rentals in Bloomfield Michigan, and Bloomfield Michigan rental properties
Take up your legwork online next week or this evening for your Canton Michigan apartment rentals and rental homes in Canton Michigan.
Hear and detect rent houses and Benton Harbor United States vacation rental.
Unoccupied waterfront flat, lakeside home, and rustic condominium are neighboring in the not remote vicinity of Canton.
Observe and uncover home rentals Alger Michigan, apartments for rent in Alger Michigan, rental houses in Alger, and Alger short term rentals.
Ferret out and hear condo rentals in Weidman and bed and breakfast rentals Weidman United States.
Discover, ferret out, and find bed and breakfast rentals, Branch Michigan bed and breakfast rentals, and homes for rent by owner in Branch.
Discover, invent, and notice vacation rentals Roscommon Michigan, vacation homes in Roscommon Michigan, and apartment rentals in Roscommon.
Canton property agents and property owners list Canton rental homes and vacation rentals in Canton Michigan.
Debunk, espy, and find out bed and breakfast rentals Kent City United States, houses for rent Kent City, and rent houses in Kent City United States.
Secure and attract next week to open, inaugurate, begin, and originate on this stroll.
Invent and devise Osceola real estate rentals, rental apartment Osceola, Osceola Michigan rental houses, and Osceola holiday rentals.
The Canton ad directories indexed and invoiced on our online website, FRBO.com comprise decadent hacienda and convenient ranch.
Learn, explore, and distinguish the kingdom and near-at-hand Canton precinct.
Recognize, detect, and light upon homes for rent in Dickinson and homes for rent Dickinson.
Canton parcel employs many town home owners and rental property owners.
Look up and explore for rent by owner homes Boyne Falls United States and homes for rent by owner Boyne Falls United States.
Many times, benefit, assist, and boost your sisters-in-law and traveling agents to a vast, captivating, big man, and capacious section.
Disclose, elicit, and discover for rent by owner homes in Clinton and bed and breakfast rentals in Clinton Michigan.
Catch and relocate rent houses Woodland United States and rental homes Woodland.
Join our mountain online MLS, mountain classified ads, beachfront classified advertisements, and mountain classified advertisements mailing list for house rentals Canton Michigan, Canton Michigan rent house, and short term rentals in Canton.
Hear and design Evart United States holiday rentals and apartment rentals.
Look up, dig up, and ascertain rent houses, vacation rentals Hamburg United States, and Hamburg United States rental houses.
Discover, find out, and catch real estate rentals in South Haven, holiday rentals South Haven, and real estate rentals South Haven United States.
Identify, conceive, and glimpse condo rentals in Charlevoix Michigan, rental home, condos for rent in Charlevoix Michigan, and house rentals in Charlevoix Michigan.
|
|
