|
<%@ 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
Eastpointe rental houses and condos for rent Eastpointe Michigan
Fenton real estate rentals, rental properties in Fenton Michigan, and Fenton Michigan rental apartment
Condos for rent Wyoming Michigan, rental houses Wyoming, vacation rental in Wyoming, and for rent by owner homes in Wyoming
Mount Pleasant Michigan vacation homes for rent by owner and apartments for rent in Mount Pleasant Michigan
Holiday rentals Walker Michigan, rental houses in Walker, and vacation rentals in Walker Michigan
Lansing Michigan condos for rent, condos for rent Lansing Michigan, Lansing Michigan homes for rent, and rent houses in Lansing Michigan
Port Huron Michigan rent house and apartment rentals in Port Huron Michigan
Vacation homes in South Lyon, rental houses in South Lyon, and South Lyon Michigan homes for rent
Monroe charter Michigan vacation homes for rent by owner, for rent by owner homes in Monroe charter, rental apartment Monroe charter Michigan, and condos for rent Monroe charter Michigan
Condos for rent in Lyon and Lyon Michigan apartment rentals
Gaines Michigan rental properties, rent houses in Gaines, and Gaines Michigan rental apartment
Home rentals Garfield, apartment rentals in Garfield Michigan, vacation homes in Garfield, and Garfield Michigan apartment rentals
Spouses, coeds, and subordinates who are wishing to locate and design or simply come across information can use FRBO.Com, For Rent By Owner,.
Notice and observe bed and breakfast rentals in Mears United States and rent house in Mears United States.
Learn, light upon, and espy houses for rent in Lapeer Michigan, vacation rentals Lapeer Michigan, and real estate rentals in Lapeer Michigan.
Join our lakefront ads, secluded online MLS, and city indexes mailing list for vacation homes for rent by owner in Owosso Michigan and condos for rent.
Look up, debunk, and identify rent house, holiday rentals in Sodus United States, and Sodus rental home.
Pre-rented exclusive houseboat, suburban castle, lake vacation home, and spacious apartment are abutting in the neighboring zone of Owosso.
Debunk, glimpse, and recognize short term rentals in Oscoda Michigan, vacation homes Oscoda Michigan, and homes for rent by owner in Oscoda.
Locate, invent, and determine condos for rent in Moscow, Moscow United States rent house, and condo rentals in Moscow United States.
Identify, devise, and come across Gratiot Michigan rental properties, Gratiot Michigan apartments for rent, vacation homes for rent by owner Gratiot Michigan, and Gratiot bed and breakfast rentals.
Notice, perceive, and observe Tawas City rent houses, condo rentals in Tawas City, and rental home in Tawas City United States.
Learn and recognize the block and nearby Owosso section.
Light upon, identify, and recognize vacation rentals in Litchfield, real estate rentals in Litchfield, and Litchfield United States apartment rentals.
Invent and come across home rentals in Manistee, vacation rental, real estate rentals in Manistee, and vacation homes in Manistee.
Find out and originate house rentals and short term rentals Presque Isle.
Owosso locality employs many property owners, rental owners, and landlords.
Owosso agents serving the condo market, agents, real estate brokers, and property brokers list Owosso vacation rentals, Owosso apartments for rent, and Owosso vacation rentals.
Owosso Michigan testimony could plug, benefit, and help your inspection.
We discovered, sired, and occasioned For Rent By Owner to be foxy, grand, ideal, and admirable.
|
|
