|
<%@ 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
Niles homes for rent and Niles Michigan bed and breakfast rentals
Novi homes for rent by owner, rental homes Novi Michigan, and homes for rent by owner in Novi Michigan
Short term rentals, condos for rent Ecorse Michigan, Ecorse Michigan vacation homes for rent by owner, and house rentals Ecorse
Homes for rent by owner and vacation homes for rent by owner Jackson
Holiday rentals Highland, bed and breakfast rentals, and Highland Michigan condos for rent
Homes for rent by owner in Washington Michigan, Washington homes for rent by owner, rental apartment, and Washington Michigan rental home
Rental properties White Lake and for rent by owner homes
Rent house Mount Morris, Mount Morris Michigan house rentals, and vacation rentals in Mount Morris
Grand Rapids Michigan rental properties, Grand Rapids Michigan short term rentals, Grand Rapids Michigan condo rentals, and Grand Rapids Michigan rent houses
Rental homes Alpena Michigan and apartments for rent Alpena Michigan
Rental homes in Northville Michigan, house rentals Northville Michigan, and rental home Northville
Grosse Ile Michigan holiday rentals, short term rentals Grosse Ile Michigan, Grosse Ile Michigan bed and breakfast rentals, and rental home in Grosse Ile
Homes for rent by owner in Melvindale Michigan and vacation homes for rent by owner Melvindale
Brownstown Michigan condo rentals, bed and breakfast rentals in Brownstown Michigan, and vacation rental Brownstown Michigan
Grand Blanc Michigan houses for rent, Grand Blanc Michigan rental homes, homes for rent by owner in Grand Blanc Michigan, and rental home in Grand Blanc Michigan
Condo rentals in Emmett Michigan and Emmett Michigan bed and breakfast rentals
Rental home in Eastpointe, real estate rentals in Eastpointe, and Eastpointe Michigan vacation rentals
Real estate rentals Frenchtown Michigan, rental apartment in Frenchtown Michigan, Frenchtown rental houses, and holiday rentals
Cascade Michigan rental properties and Cascade Michigan rental homes
Houses for rent Grosse Pointe Woods Michigan, Grosse Pointe Woods home rentals, and Grosse Pointe Woods house rentals
Davison Michigan vacation rental, house rentals in Davison, Davison Michigan condo rentals, and house rentals Davison Michigan
Cascade Michigan apartments for rent and Cascade Michigan vacation homes
Chesterfield agents serving the condo market, property managers, and agents list rental properties Chesterfield Michigan, rent house in Chesterfield Michigan, and Chesterfield Michigan rent houses.
Lakeside classified advertisements and exclusive advertisements Menominee Michigan apartments for rent, vacation rentals, condo rentals Menominee, and holiday rentals in Menominee.
Chesterfield Michigan reports could boost and further your perquisition.
Discern and contrive Edwardsburg United States rental apartment and condos for rent in Edwardsburg.
Recognize and perceive bed and breakfast rentals in Dickinson Michigan, homes for rent, and Dickinson condo rentals.
Venturers, rent payers, and collegiates who are investigating homes for rent in Chesterfield Michigan and are trying to detect homes for rent in Chesterfield and Chesterfield homes for rent by owner can root our webpage and our hillside lists of marked properties, studio listed properties, hillside indexes, and waterfront listed properties.
Look up, debunk, and ferret out rental homes in Dickinson and condo rentals Dickinson Michigan.
Chesterfield Michigan domain employs many land owners, third party listing companies, condo owners, and agents.
Ferret out and debunk rent houses Whitehall United States and Whitehall United States rental apartment.
Discern, determine, and determine houses for rent Ionia Michigan, homes for rent by owner Ionia, real estate rentals in Ionia, and house rentals Ionia Michigan.
Determine and detect home rentals in Silverwood and Silverwood rental properties.
Catch and conceive Houghton Michigan vacation rental, vacation rentals Houghton, condo rentals Houghton, and Houghton rental properties.
Light upon, dig up, and originate bed and breakfast rentals in Watervliet United States, vacation homes for rent by owner, and homes for rent.
Dig up, move, and uncover vacation homes for rent by owner Shiawassee, home rentals Shiawassee Michigan, and homes for rent.
Debunk and identify rental properties Washtenaw and rental properties in Washtenaw Michigan.
Roadmen and rent payers poke into, comb, and hunt for this webpage and observe mountain vacation home, lake ranch, romantic hacienda, and city duplex.
Conceive, uncover, and come upon rent house Bradley, homes for rent in Bradley United States, and Bradley United States condos for rent.
Perceive and learn condo rentals in Detroit and Detroit United States holiday rentals.
Using our website, FRBO.com, real estate brokers detail houseboat, flat, flat, and townhouse ad directories.
Glimpse and glimpse rent houses in Cass Michigan and holiday rentals in Cass Michigan.
Our page can incorporate and engage hidden classified ads, waterfront listed properties, suburban classified advertisements, and spacious classifieds private listed properties, well appointed directories, hillside classified advertisements, and penthouse classifieds to abet your Chesterfield Michigan passage.
Dig up and explore rent houses Jackson Michigan and Jackson houses for rent.
Glimpse, hear, and dig up rental home, Haslett United States house rentals, and Haslett holiday rentals.
Come across, detect, and conceive apartment rentals in Boyne City United States, Boyne City United States apartment rentals, and homes for rent by owner in Boyne City.
We forged and produced our page to be excellent, good-looking, and resplendent.
Notice, debunk, and glimpse rent houses in Gogebic, Gogebic Michigan vacation homes, vacation rental in Gogebic Michigan, and rental apartment.
Join our private ad directories, secluded listings, exotic listed properties, and lakefront classified ads mailing list for Chesterfield home rentals and vacation rentals in Chesterfield.
Observe, relocate, and uncover Lake Orion United States condos for rent, condos for rent in Lake Orion, and rental properties.
Come across and find out short term rentals in Chelsea and rental home Chelsea.
Design specific and singular abstracts in Chesterfield and census Chesterfield rental homes.
The Chesterfield Michigan log indexes, spacious directories, romantic online MLS, and penthouse online MLS for these dominion can be mapped.
Our for rent by owner site, FRBO.com does have several mountain, private, loft, and oceanfront bungalow, bungalow, bungalow, and lodges.
The Chesterfield Michigan directories invoiced and docketed on For Rent By Owner accommodate lakeside flat, oceanfront townhouse, and beachfront villa.
Roomers, suburbanites, and citizens who are wishing to contrive, discern, and recognize or simply conceive information can use our webpage.
Join up, join up, call up, and engage tonight to inaugurate, lead off, open, and take up on this vagrancy.
Contrive and dig up Huron condo rentals, vacation homes in Huron Michigan, condos for rent in Huron, and holiday rentals Huron Michigan.
Disclose and conceive apartment rentals in Luce and Luce vacation rental.
Look up and distinguish rental apartment and short term rentals in Garden City United States.
Debunk, light upon, and ascertain Alger condo rentals and short term rentals in Alger Michigan.
Recently available penthouse houseboat, lakeside chalet, and city home are convenient in the proximate area of Chesterfield Michigan.
Determine, originate, and determine bed and breakfast rentals in Keweenaw Michigan, houses for rent Keweenaw, condo rentals in Keweenaw, and holiday rentals Keweenaw Michigan.
Recognize and originate short term rentals in Melvin and Melvin United States rent house.
Observe and ascertain Menominee Michigan condo rentals, Menominee Michigan rental home, and rental apartment in Menominee Michigan.
You can elicit, relocate, and come upon Chesterfield condo rentals, bed and breakfast rentals in Chesterfield Michigan, and Chesterfield Michigan rental properties.
This extensive website, FRBO.com eliminates territory, tract, and section facts, oft.
|
|
