|
<%@ 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
Vacation rentals in Milford Michigan and Milford Michigan home rentals
Rent house, Shelby charter Michigan homes for rent, and Shelby charter real estate rentals
Rental homes in Saginaw, houses for rent, Saginaw Michigan vacation homes for rent by owner, and rental properties in Saginaw
Apartment rentals and apartment rentals Wayne
Holiday rentals Benton charter, bed and breakfast rentals Benton charter, and apartments for rent in Benton charter
Holiday rentals Vienna Michigan, homes for rent in Vienna Michigan, Vienna Michigan homes for rent, and short term rentals in Vienna Michigan
Real estate rentals in Taylor and apartments for rent
For rent by owner homes Flushing Michigan, vacation rental, and vacation rental in Flushing Michigan
House rentals in Eastpointe Michigan, home rentals in Eastpointe, Eastpointe Michigan vacation homes, and Eastpointe Michigan rental home
Rental properties and Walker homes for rent
Short term rentals Davison, apartment rentals Davison, and rental houses
Rental apartment in Grosse Ile, condo rentals in Grosse Ile Michigan, Grosse Ile Michigan condo rentals, and rent house in Grosse Ile Michigan
Highland Park Michigan rent house and Highland Park Michigan real estate rentals
Owosso houses for rent, rental properties in Owosso Michigan, and Owosso Michigan for rent by owner homes
Homes for rent by owner in Sturgis Michigan, Sturgis Michigan apartments for rent, apartment rentals in Sturgis Michigan, and Sturgis bed and breakfast rentals
Vacation rentals Georgetown Michigan and Georgetown Michigan rental home
Rental homes, Macomb Michigan for rent by owner homes, and condos for rent Macomb Michigan
Apartment rentals, rental home Monitor Michigan, Monitor Michigan apartments for rent, and apartments for rent
Bed and breakfast rentals Romulus Michigan and apartment rentals in Romulus
Melvindale apartments for rent, rent houses, and rent houses in Melvindale Michigan
Notice, disclose, and determine vacation homes for rent by owner, short term rentals Gladwin Michigan, and rent houses Gladwin.
This website, FRBO.com incorporates township and locality poop, not infrequently.
Uncover and catch rent house and rental home Arenac.
Notice and move the territory and not far away Kalamazoo Michigan square.
Kalamazoo field employs many property brokers, property owners, agents, and agents serving the condo market.
Perceive and look up rent houses in Oceana Michigan and real estate rentals.
Observe, distinguish, and notice for rent by owner homes in Osceola and homes for rent in Osceola.
Our site, FRBO.com can admit and interest suburban classified advertisements and waterfront ad directories waterfront listings, log classifieds, penthouse listed properties, and lakefront ads to support your Kalamazoo Michigan sally.
Kalamazoo Michigan figures could stump, bail out, and expedite your inspection.
Ferret out, conceive, and explore Greenland vacation homes for rent by owner, bed and breakfast rentals Greenland United States, and Greenland United States rent houses.
Perceive and discover St. Clair apartments for rent and St. Clair Michigan houses for rent.
Espy and explore home rentals, homes for rent, and short term rentals Chippewa.
Detect, locate, and uncover Sunfield United States rental homes, Sunfield United States holiday rentals, and house rentals in Sunfield United States.
Come across and ascertain short term rentals in Maple City United States and Maple City home rentals.
Devise and ascertain Tipton United States vacation rentals and holiday rentals in Tipton United States.
You can find and debunk vacation homes for rent by owner in Kalamazoo Michigan and house rentals Kalamazoo Michigan.
Sisters and speculators who are looking for Kalamazoo Michigan condo rentals and are trying to conceive vacation rentals in Kalamazoo Michigan and rent houses in Kalamazoo Michigan can probe this site, FRBO.com and our suburban lists of marked properties, log lists of marked properties, and spacious lists of marked properties.
Kalamazoo real estate brokers and home owners list house rentals in Kalamazoo Michigan, Kalamazoo Michigan houses for rent, Kalamazoo rent house, and Kalamazoo Michigan rent houses.
Ferret out, devise, and find out real estate rentals in Tuscola Michigan, rental houses in Tuscola Michigan, apartments for rent, and Tuscola Michigan rental home.
Disclose, move, and invent holiday rentals, rental properties, and rent houses in Nashville.
See convenient indexes, exclusive classified advertisements, studio advertisements, and waterfront online MLS that property managers and real estate agents post on this site, For Rent By Owner (FRBO.com).
Relocate and determine house rentals in Roscommon, rental properties Roscommon, vacation rentals, and Roscommon real estate rentals.
Uncover, discern, and look up Ionia Michigan rental home, Ionia rental homes, for rent by owner homes, and vacation homes Ionia.
Itinerants, professors, and householders who are wishing to dig up and recognize or simply catch information can use FRBO.Com, For Rent By Owner,.
Look up, hear, and discover Perronville United States condo rentals, apartment rentals in Perronville United States, and Perronville United States condo rentals.
|
|
