|
<%@ 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
Holiday rentals Hazel Park and short term rentals in Hazel Park Michigan
Rental homes, rent house in Waterford Michigan, and Waterford Michigan vacation rentals
Ypsilanti Michigan vacation homes for rent by owner, rental properties, houses for rent Ypsilanti, and rental apartment in Ypsilanti Michigan
Short term rentals Ferndale and Ferndale Michigan house rentals
Vacation homes for rent by owner in Pontiac Michigan, real estate rentals in Pontiac, and Pontiac Michigan vacation rental
Rental home in Ionia Michigan, Ionia rental apartment, rental homes, and houses for rent in Ionia Michigan
Grosse Ile Michigan vacation rentals and Grosse Ile Michigan condo rentals
Alpine Michigan holiday rentals, short term rentals in Alpine, and home rentals Alpine
Houses for rent, rent house Muskegon Michigan, home rentals Muskegon, and house rentals in Muskegon
Short term rentals Georgetown and vacation homes in Georgetown
Rental apartment Northville, vacation homes Northville Michigan, and short term rentals Northville
East Grand Rapids Michigan vacation homes, homes for rent East Grand Rapids, East Grand Rapids rental properties, and vacation rentals East Grand Rapids
Apartments for rent in Redford Michigan and Redford Michigan houses for rent
Condos for rent Canton Michigan, Canton Michigan rental properties, and vacation homes for rent by owner Canton Michigan
Rent house in Benton charter Michigan, Benton charter Michigan rental homes, Benton charter Michigan houses for rent, and bed and breakfast rentals in Benton charter
Ferret out, notice, and observe vacation homes for rent by owner in Calhoun Michigan, Calhoun rental homes, and home rentals in Calhoun Michigan.
See private advertisements, city listed properties, and hidden ads that property owners and agents serving the condo market post on this website, FRBO.com.
Discern, light upon, and uncover Keweenaw Michigan rental properties, vacation rental in Keweenaw Michigan, and Keweenaw Michigan vacation rentals.
Find and debunk Menominee Michigan rent house, homes for rent in Menominee Michigan, and rental homes.
Join our exotic ads, hidden classified advertisements, and decadent ads mailing list for homes for rent by owner, rent houses, and rental home in Coldwater.
Observe peculiar, specific, and various memorandums in Coldwater and peg vacation rentals in Coldwater Michigan.
Notice and relocate real estate rentals Mason Michigan, short term rentals Mason Michigan, rental apartment Mason Michigan, and house rentals Mason Michigan.
Look up, ferret out, and come upon short term rentals Genesee Michigan, Genesee Michigan short term rentals, holiday rentals in Genesee Michigan, and Genesee rent houses.
Conceive, detect, and design Hillsdale houses for rent and house rentals in Hillsdale.
Using FRBO.Com, For Rent By Owner,, property owners chart castle and hacienda directories.
Originate, discern, and explore apartments for rent in Allegan Michigan, vacation homes for rent by owner in Allegan Michigan, and Allegan Michigan condos for rent.
We made, formed, and formulated our online website, FRBO.com to be admirable and foxy.
Waterfront online MLS and beach directories rent houses, rental properties, Jackson Michigan homes for rent by owner, and holiday rentals Jackson Michigan.
Elicit and invent Wexford Michigan bed and breakfast rentals, apartments for rent Wexford Michigan, and rent houses in Wexford Michigan.
Move and find out Boon United States rental apartment and for rent by owner homes.
Move, locate, and come across Eben Junction United States houses for rent, holiday rentals in Eben Junction, and Eben Junction United States rent houses.
Recognize, originate, and invent Sault Sainte Marie United States condo rentals, Sault Sainte Marie United States apartments for rent, and rent houses in Sault Sainte Marie United States.
Adventurers and counterparts ransack and scour our page and come across beach apartment, spacious houseboat, log bungalow, and studio hacienda.
Perceive, detect, and ascertain Carp Lake rental home, Carp Lake United States rent house, and vacation rentals Carp Lake.
Learn and detect Wabaningo United States rental home and Wabaningo United States condo rentals.
Light upon and invent the tract and nearby Coldwater Michigan vicinity.
Locate and dig up homes for rent by owner in Gladstone and rent house Gladstone.
Salesmen, inhabitants, and adventurers who are wishing to recognize, conceive, and light upon or simply disclose information can use this site, For Rent By Owner (FRBO.com).
|
|
