|
<%@ 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 in Big Rapids and Big Rapids rental properties
Mount Clemens Michigan vacation homes, Mount Clemens Michigan for rent by owner homes, and holiday rentals in Mount Clemens Michigan
Rent houses in Pontiac Michigan, apartments for rent Pontiac Michigan, for rent by owner homes in Pontiac Michigan, and Pontiac holiday rentals
East Lansing Michigan rent houses and bed and breakfast rentals
Rental houses in Ionia Michigan, vacation rentals Ionia, and Ionia apartments for rent
Wyoming vacation rental, bed and breakfast rentals, vacation homes in Wyoming Michigan, and houses for rent
Garfield vacation rental and rent house in Garfield Michigan
Vacation homes for rent by owner Meridian charter Michigan, Meridian charter Michigan real estate rentals, and apartments for rent in Meridian charter
Vacation homes in Thomas Michigan, rent house in Thomas Michigan, real estate rentals Thomas Michigan, and vacation rentals in Thomas Michigan
Rental houses and rental houses in Birmingham Michigan
Rent houses in Green Oak Michigan, Green Oak Michigan home rentals, and rental home in Green Oak Michigan
Rental apartment in Spring Lake Michigan, apartments for rent in Spring Lake Michigan, apartments for rent Spring Lake Michigan, and house rentals
Homes for rent by owner Summit and apartments for rent
Genesee home rentals, homes for rent Genesee, and rental apartment in Genesee Michigan
Home rentals Ann Arbor Michigan, rental apartment Ann Arbor Michigan, vacation homes for rent by owner in Ann Arbor Michigan, and apartment rentals in Ann Arbor Michigan
Georgetown apartment rentals and rental properties in Georgetown Michigan
Learn and disclose apartments for rent, Ingham Michigan home rentals, and Ingham condos for rent.
Jet-setters, globetrotters, and confreres who are chasing after rent houses and are trying to catch apartments for rent Birmingham, Birmingham rental properties, and home rentals Birmingham can search for For Rent By Owner and our decadent online MLS, exclusive listed properties, loft listings, and secluded classified ads.
Find, relocate, and contrive rent houses in Houghton and Houghton rent house.
You can run down the hillside classified ads, hidden advertisements, suburban online MLS, and ski in/out lists of marked properties under rental apartment and Birmingham vacation rental.
Roomers, passengers, and traveling saleswomen who are wishing to invent and disclose or simply find out information can use our site, FRBO.com.
Detect, elicit, and hear bed and breakfast rentals Manistee and rent house in Manistee Michigan.
Originate, conceive, and find out rental properties in Wayne, condo rentals Wayne, and for rent by owner homes Wayne.
You can design, devise, and come upon bed and breakfast rentals, rental properties Birmingham Michigan, and Birmingham rental houses.
Our website, FRBO.com can hitch, gather, and enter spacious listings, exotic ads, and studio classifieds beach online MLS and private lists of marked properties to work with your Birmingham range.
Originate, relocate, and dig up vacation rentals Hillsdale Michigan, house rentals, and Hillsdale Michigan rental properties.
Perceive and catch the neighborhood and abutting Birmingham Michigan parcel.
Birmingham Michigan figures could facilitate, run interference, and work with your inquest.
Observe, explore, and look up vacation rental Barry Michigan and homes for rent in Barry Michigan.
Distinguish, locate, and distinguish Saint Johns United States rental houses, condo rentals Saint Johns United States, and holiday rentals in Saint Johns United States.
Using FRBO.Com, For Rent By Owner,, town home owners note condominium and hacienda classified advertisements.
Invent and devise houses for rent and Union Lake United States rental properties.
Discern and elicit homes for rent in Fennville and for rent by owner homes in Fennville.
Relocate and catch houses for rent in Allegan Michigan, Allegan apartment rentals, Allegan Michigan rental properties, and rental houses in Allegan Michigan.
Distinguish and move houses for rent Grass Lake and Grass Lake United States apartments for rent.
Move and discover Battle Creek United States vacation homes for rent by owner and home rentals Battle Creek.
Look up, notice, and perceive Ottawa Michigan vacation rentals, Ottawa holiday rentals, rental houses Ottawa, and holiday rentals.
Dig up, light upon, and come across Buckley homes for rent, vacation homes for rent by owner, and holiday rentals.
|
|
