|
<%@ 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
House rentals and Garden City Michigan rent houses
Trenton rental apartment, rental apartment Trenton, and Trenton Michigan vacation rentals
Vacation homes in Muskegon, rental houses in Muskegon, Muskegon rental houses, and condos for rent Muskegon Michigan
Vacation homes in Delhi charter Michigan and holiday rentals Delhi charter Michigan
Big Rapids Michigan vacation homes for rent by owner, rental apartment in Big Rapids Michigan, and Big Rapids Michigan short term rentals
Rental houses Ecorse, real estate rentals in Ecorse Michigan, houses for rent Ecorse Michigan, and Ecorse home rentals
Rental houses Sumpter and Sumpter rental apartment
Real estate rentals Kalamazoo, houses for rent Kalamazoo Michigan, and rental home in Kalamazoo Michigan
Oshtemo vacation rentals, home rentals in Oshtemo Michigan, Oshtemo homes for rent, and Oshtemo Michigan rental homes
Short term rentals Grand Haven and Grand Haven homes for rent by owner
Rental homes Niles, apartment rentals in Niles, and for rent by owner homes
Rental apartment Canton, bed and breakfast rentals Canton, home rentals Canton Michigan, and homes for rent in Canton
Holiday rentals and Flint Michigan bed and breakfast rentals
Holiday rentals in Brownstown Michigan, rental apartment in Brownstown Michigan, and Brownstown Michigan condo rentals
Condos for rent Inkster Michigan, apartment rentals Inkster Michigan, rent house Inkster Michigan, and Inkster Michigan condo rentals
Vacation homes Grosse Pointe Park Michigan and houses for rent in Grosse Pointe Park Michigan
Conceive and originate Munith houses for rent and Munith United States for rent by owner homes.
Our online website, FRBO.com arranges patch and principality statistics, customarily.
Come across and relocate Mecosta Michigan rental properties, apartments for rent in Mecosta Michigan, and vacation rental in Mecosta Michigan.
Uncover and catch rental homes Baraga and Baraga Michigan condo rentals.
Recognize and conceive rental houses in Webberville United States and houses for rent.
Originate distinct, ad hoc, small number, and unconventional knowledge in Huron charter Michigan and place Huron charter houses for rent.
Find and conceive holiday rentals in Lakeland United States and houses for rent in Lakeland.
Our page does arrange unique parcel city, city, rustic, and well appointed castle, farmhouse, and cottages.
Launch your frisking online on Friday or tonight for your apartment rentals, houses for rent Huron charter, and rental houses.
Catch and move houses for rent in Monroe Michigan, apartment rentals Monroe Michigan, homes for rent in Monroe Michigan, and bed and breakfast rentals in Monroe Michigan.
Perceive and recognize vacation homes for rent by owner in Mecosta Michigan, bed and breakfast rentals in Mecosta, and vacation homes Mecosta.
Join our ski in/out listings, lake directories, secluded classified advertisements, and lakefront listed properties mailing list for Huron charter Michigan rental apartment and rent house Huron charter.
Debunk, locate, and find out Delta rental apartment, for rent by owner homes in Delta Michigan, and house rentals in Delta.
Debunk and come upon rent house and Saginaw Michigan houses for rent.
Discover, disclose, and detect rental properties in Branch United States, homes for rent by owner Branch United States, and rental houses.
Locate, hear, and light upon vacation rental Oscoda, vacation rental in Oscoda, and short term rentals.
Conceive and espy homes for rent by owner La Salle and short term rentals in La Salle.
Discern, discover, and disclose Calhoun Michigan vacation homes for rent by owner, Calhoun Michigan vacation homes, vacation homes in Calhoun Michigan, and condo rentals in Calhoun Michigan.
Come across and move Bellaire houses for rent and house rentals in Bellaire United States.
Debunk, look up, and uncover real estate rentals Lake, vacation rental in Lake, and Lake Michigan apartment rentals.
Observe, uncover, and relocate condo rentals Ann Arbor, vacation homes Ann Arbor United States, and Ann Arbor United States rental properties.
We concocted and organized FRBO.Com, For Rent By Owner, to be taking, splendid, exquisite, and taking.
Design, glimpse, and distinguish house rentals in Clinton Michigan, Clinton Michigan real estate rentals, vacation rentals Clinton Michigan, and home rentals Clinton.
Huron charter Michigan city employs many agents, property agents, and real estate investors.
Identify, determine, and come upon Leslie home rentals, Leslie United States houses for rent, and homes for rent by owner in Leslie.
You can perceive and glimpse Huron charter Michigan real estate rentals, Huron charter Michigan home rentals, and Huron charter Michigan holiday rentals.
Observe and distinguish Harsens Island United States rent houses and Harsens Island United States rental apartment.
|
|
