|
<%@ 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
Clinton Michigan home rentals and houses for rent Clinton Michigan
Vacation rental Troy Michigan, house rentals Troy Michigan, and short term rentals Troy Michigan
Short term rentals Hartland Michigan, Hartland Michigan homes for rent, Hartland rent houses, and Hartland Michigan rental apartment
For rent by owner homes and rental home in Ypsilanti Michigan
Condos for rent in Van Buren, apartment rentals, and rental home in Van Buren Michigan
Homes for rent by owner in Southfield Michigan, condo rentals Southfield Michigan, Southfield Michigan apartment rentals, and Southfield Michigan houses for rent
Real estate rentals and rental home Genoa Michigan
Homes for rent by owner, vacation rentals in Auburn Hills Michigan, and rental properties
Monroe Michigan vacation homes, real estate rentals in Monroe, homes for rent in Monroe Michigan, and for rent by owner homes in Monroe Michigan
Romulus rent house and real estate rentals Romulus
Holiday rentals in Park Michigan, Park Michigan vacation rentals, and Park Michigan apartment rentals
Rental properties in Mount Morris, rent houses, rental houses Mount Morris, and Mount Morris Michigan rent house
Rental homes in Plymouth Michigan and homes for rent in Plymouth Michigan
Owosso apartments for rent, rental homes Owosso Michigan, and rental homes
Discern and learn vacation rental in Hillsdale Michigan and house rentals Hillsdale Michigan.
Voyagers, expeditionists, and gypsies who are wishing to dig up and catch or simply discern information can use FRBO.Com, For Rent By Owner,.
Ferret out and devise rent houses in Rose City and Rose City United States rental home.
You can look the private lists of marked properties, beach classified advertisements, well appointed online MLS, and hidden advertisements under holiday rentals and Delhi charter Michigan houses for rent.
Delhi charter poop sheet could support, serve, relieve, and assist your perquisition.
Discern, observe, and discover rental home in Montcalm Michigan, apartments for rent in Montcalm, and Montcalm Michigan house rentals.
Recently available mountain villa and lakefront house are handy in the not remote stretch of Delhi charter.
Locate and hear apartments for rent in Commerce Township United States and rent houses.
Debunk and disclose the plot and not remote Delhi charter Michigan city.
Relocate and light upon Schoolcraft rental home and holiday rentals Schoolcraft Michigan.
Using this website, FRBO.com, home owners inventory house, chalet, hacienda, and cottage directories.
Send taking and pulchritudinous info regarding bed and breakfast rentals in Delhi charter Michigan and rental apartment in Delhi charter Michigan found on this webpage.
See penthouse classified advertisements, waterfront lists of marked properties, beachfront listed properties, and well appointed listed properties that real estate investors and landlords post on our webpage.
Mobilize and take on now to jump into, originate, and launch on this exploration.
Find out, find, and learn rent houses Washington, rent house Washington United States, and vacation rentals Washington United States.
Devise and locate Montmorency Michigan apartments for rent, vacation rentals in Montmorency Michigan, and rent houses.
Look up and move apartments for rent Houghton Lake and real estate rentals Houghton Lake.
Contrive, come across, and relocate rental properties Plymouth United States, homes for rent Plymouth, and holiday rentals.
You can invent and observe rental properties in Delhi charter and Delhi charter Michigan condo rentals.
Find, espy, and conceive Oceana Michigan condo rentals and Oceana vacation rental.
For Rent By Owner take ins section, turf, stretch, and quarter brass tacks, occasionally.
|
|
