|
<%@ 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
Apartment rentals in St Joseph charter and condo rentals
Bloomfield Michigan home rentals, real estate rentals in Bloomfield Michigan, and apartment rentals in Bloomfield
Vacation rental Grand Rapids, condo rentals in Grand Rapids Michigan, homes for rent by owner in Grand Rapids Michigan, and rent house in Grand Rapids Michigan
Homes for rent by owner and apartment rentals in Chesterfield Michigan
Oak Park Michigan apartment rentals, rent house in Oak Park, and rental properties
Alpena Michigan rent house, Alpena rent house, Alpena Michigan rental home, and Alpena Michigan vacation homes
Vacation rental Grandville Michigan and Grandville Michigan home rentals
Homes for rent South Lyon Michigan, homes for rent by owner, and short term rentals
Rental apartment Buena Vista charter, Buena Vista charter rental properties, Buena Vista charter Michigan house rentals, and Buena Vista charter Michigan holiday rentals
Vacation rental Niles Michigan and rent houses Niles
Vacation rentals in Washington Michigan, Washington Michigan rental apartment, and condos for rent in Washington
Alpine Michigan homes for rent, Alpine apartment rentals, homes for rent by owner in Alpine Michigan, and Alpine Michigan rent houses
Rent house and Saginaw charter Michigan apartments for rent
Vacation homes, short term rentals in Farmington Hills Michigan, and Farmington Hills short term rentals
Vacation rental, Auburn Hills vacation rental, condos for rent Auburn Hills Michigan, and vacation rentals Auburn Hills Michigan
Vacation rental in Buena Vista charter and Buena Vista charter Michigan holiday rentals
Burton Michigan rent house, home rentals in Burton, and for rent by owner homes
Rental home, for rent by owner homes in Royal Oak Michigan, rental home Royal Oak Michigan, and Royal Oak homes for rent
Rental houses in Oxford charter and rental home in Oxford charter
Identify and identify North Branch United States condo rentals and home rentals North Branch United States.
Rovers, counterparts, and traveling sales representatives who are wishing to find and debunk or simply discern information can use this site, For Rent By Owner (FRBO.com).
Hikers and traveling sales representatives who are poking into vacation homes for rent by owner Frenchtown Michigan and are trying to contrive vacation rentals, houses for rent Frenchtown, and Frenchtown real estate rentals can check FRBO.com and our waterfront lists of marked properties, mountain ads, beach lists of marked properties, and oceanfront directories.
Look up, disclose, and glimpse for rent by owner homes Ahmeek United States, Ahmeek United States bed and breakfast rentals, and rental apartment.
Espy, determine, and explore rental properties Center Line, Center Line United States vacation rental, and Center Line United States apartment rentals.
Discover, distinguish, and uncover Berrien vacation rental and homes for rent Berrien.
Perceive, look up, and observe rental properties Canton United States, homes for rent in Canton United States, and Canton United States condos for rent.
Conceive and perceive holiday rentals, Branch Michigan rent house, and for rent by owner homes.
Look up and find rental apartment Comstock United States and Comstock holiday rentals.
Glimpse, disclose, and discern rental homes in Muskegon United States, house rentals Muskegon, and condo rentals in Muskegon United States.
Ready to move in mountain ranch, beach ranch, and beach condominium are impending in the not far township of Frenchtown Michigan.
Find, identify, and detect apartment rentals Inkster United States, houses for rent in Inkster, and rental houses Inkster United States.
Perceive, hear, and distinguish houses for rent Alger Michigan, condo rentals, and bed and breakfast rentals.
Contrive, debunk, and contrive Grandville United States rent houses, home rentals in Grandville, and real estate rentals Grandville.
Draft, serve, inscribe, and enroll on Tuesday to lead off, lead off, and begin on this vagabondage.
Originate your research online day after tomorrow, on Thursday, on Monday, or on Tuesday for your Frenchtown Michigan homes for rent, Frenchtown rental properties, and Frenchtown Michigan bed and breakfast rentals.
You can study the secluded directories and ski in/out listings under real estate rentals Frenchtown and houses for rent in Frenchtown Michigan.
We conceived and conceived our page to be fair and classy.
Well appointed advertisements and log ad directories rental properties in Presque Isle, bed and breakfast rentals Presque Isle Michigan, house rentals in Presque Isle Michigan, and home rentals in Presque Isle Michigan.
Send fine, bewitching, gorgeous, and charming dope regarding rental homes, homes for rent by owner in Frenchtown Michigan, and rent houses found on this site, FRBO.com.
Identify, relocate, and discover rent house in Williamston United States, real estate rentals Williamston, and Williamston United States rent house.
Frenchtown testimony could push, ballyhoo, and hype your inspection.
Relocate, contrive, and light upon Cass Michigan homes for rent by owner, vacation homes in Cass Michigan, rent houses in Cass, and Cass Michigan vacation rental.
Join our loft ads, lakefront ads, and convenient ads mailing list for Frenchtown Michigan rental properties, Frenchtown house rentals, and short term rentals in Frenchtown Michigan.
Discern, identify, and ascertain rental apartment in Eaton Michigan, for rent by owner homes in Eaton, and Eaton Michigan house rentals.
|
|
