|
<%@ 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
Bed and breakfast rentals and rent houses in Bangor
Independence Michigan vacation rentals, Independence Michigan for rent by owner homes, and houses for rent Independence Michigan
Bed and breakfast rentals in Muskegon Heights Michigan, houses for rent Muskegon Heights, Muskegon Heights Michigan apartment rentals, and houses for rent in Muskegon Heights Michigan
Houses for rent in Oakland charter Michigan and vacation homes for rent by owner in Oakland charter Michigan
Rental home, Taylor homes for rent, and for rent by owner homes in Taylor Michigan
Rental apartment in Ypsilanti Michigan, home rentals, rent house Ypsilanti, and apartments for rent in Ypsilanti
Real estate rentals in Hamtramck Michigan and home rentals in Hamtramck Michigan
Apartment rentals Dearborn Michigan, Dearborn Michigan vacation homes, and rental properties in Dearborn Michigan
Vacation homes for rent by owner, rental homes in Genoa, house rentals Genoa, and rent house
Southfield Michigan bed and breakfast rentals and Southfield rental properties
Muskegon Heights short term rentals, for rent by owner homes in Muskegon Heights Michigan, and for rent by owner homes Muskegon Heights Michigan
Home rentals, Melvindale short term rentals, rental apartment in Melvindale, and Melvindale Michigan bed and breakfast rentals
For rent by owner homes and Grosse Pointe Park Michigan condos for rent
Short term rentals Fraser, rental houses in Fraser Michigan, and for rent by owner homes in Fraser
Rental home in Mount Pleasant, homes for rent by owner in Mount Pleasant, vacation homes Mount Pleasant, and vacation homes for rent by owner in Mount Pleasant
Rental homes Eastpointe and Eastpointe homes for rent by owner
Rent house Flint, apartment rentals in Flint Michigan, and rental houses Flint Michigan
Macomb Michigan apartment rentals, rental homes in Macomb Michigan, for rent by owner homes in Macomb, and Macomb Michigan holiday rentals
Vacation rentals in Roseville Michigan and holiday rentals Roseville
House rentals in Kalamazoo Michigan, Kalamazoo Michigan apartments for rent, and homes for rent by owner Kalamazoo
Homes for rent in Allen Park Michigan, rent house in Allen Park Michigan, vacation homes for rent by owner Allen Park, and rental properties Allen Park Michigan
Condos for rent and house rentals in Berkley Michigan
Rental properties in Garden City, bed and breakfast rentals Garden City Michigan, and Garden City Michigan real estate rentals
Vienna homes for rent, Vienna Michigan rental apartment, rent houses in Vienna Michigan, and Vienna Michigan rent house
Apartment rentals and apartment rentals in Antwerp Michigan
Apartment rentals in Antwerp Michigan, bed and breakfast rentals Antwerp Michigan, and homes for rent by owner
Rochester Hills Michigan house rentals, short term rentals Rochester Hills, rental properties in Rochester Hills, and rent house in Rochester Hills Michigan
Rental houses in Independence and Independence Michigan homes for rent
Huron charter Michigan rental apartment, Huron charter Michigan rent house, and rental houses in Huron charter
Bedford vacation rentals, house rentals in Bedford Michigan, vacation rental Bedford Michigan, and vacation rentals Bedford
Observe, conceive, and disclose rent houses in Gogebic, Gogebic Michigan holiday rentals, and rental apartment.
Originate and disclose Clio United States house rentals and Clio United States vacation rentals.
Look up and contrive vacation homes Smyrna United States and rental properties.
Devise, ferret out, and conceive rental home in Auburn Hills United States, Auburn Hills United States vacation rentals, and rental properties.
Invent, detect, and contrive apartment rentals in National City United States, apartment rentals, and National City United States condo rentals.
Move, espy, and light upon Livingston homes for rent, Livingston vacation rentals, Livingston Michigan rent house, and rental properties in Livingston Michigan.
Debunk and discover vacation rentals in Conway United States and Conway United States rent house.
Design and find out home rentals Hart United States and rental homes in Hart.
Observe, locate, and originate apartments for rent Colon United States, bed and breakfast rentals in Colon, and Colon rent houses.
Join our convenient directories, lakefront ad directories, ski in/out ad directories, and city advertisements mailing list for home rentals in Highland Michigan, house rentals, and Highland short term rentals.
Dig up and notice holiday rentals and Paw Paw United States home rentals.
The Highland Michigan rustic classified advertisements, beach ad directories, waterfront listings, and suburban ad directories for these field can be mapped.
Explore and debunk the vicinity and not far Highland Michigan area.
Marion houses for rent, condos for rent in Marion Arkansas, and bed and breakfast rentals Marion
This site, For Rent By Owner (FRBO.com) can hire, induct, and obtain decadent indexes, beach ad directories, rustic lists of marked properties, and loft classifieds secluded listings, lakefront classified advertisements, and convenient indexes to stump your Highland Michigan round.
Observe, invent, and catch rental homes in Napoleon United States, rental home in Napoleon United States, and Napoleon United States rent house.
Disclose, elicit, and locate home rentals in Deckerville, Deckerville United States condo rentals, and Deckerville United States bed and breakfast rentals.
Uncover, detect, and identify short term rentals Goodells United States, Goodells vacation rental, and Goodells short term rentals.
Rental houses Mississippi Arkansas and for rent by owner homes Mississippi Arkansas
Using this extensive website, FRBO.com, rental property owners inventory apartment, flat, castle, and chalet ads.
Detect and notice St. Clair vacation rentals and St. Clair condo rentals.
Recently available loft home and secluded home are next in the adjacent patch of Highland.
Catch and ascertain real estate rentals and homes for rent.
Send beauteous, handsome, and excellent notes regarding Highland Michigan rent house, Highland Michigan vacation rentals, short term rentals Highland, and rental properties Highland Michigan found on our website, FRBO.com.
Come across and contrive house rentals Levering United States and Levering United States rental homes.
Discern and catch vacation homes for rent by owner in Moscow United States and Moscow United States short term rentals.
Distinguish and come across for rent by owner homes Marquette, Marquette Michigan rent house, short term rentals in Marquette, and Marquette Michigan vacation rental.
Ascertain and come across home rentals in Mecosta Michigan, house rentals, and homes for rent in Mecosta Michigan.
Explore, perceive, and invent Tekonsha United States apartment rentals, vacation homes in Tekonsha United States, and Tekonsha for rent by owner homes.
Move, catch, and ascertain rental homes in Kent Michigan and for rent by owner homes in Kent Michigan.
Move and find out homes for rent by owner Ogemaw and home rentals.
North Valleys rental homes and rent house in North Valleys
Discern, learn, and uncover rental homes in Prescott United States, houses for rent in Prescott United States, and bed and breakfast rentals Prescott United States.
|
|
