|
<%@ 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
De Witt home rentals and rental homes
Vacation homes for rent by owner in Holland Michigan, Holland Michigan homes for rent by owner, and bed and breakfast rentals in Holland Michigan
Vacation rental Mundy Michigan, Mundy homes for rent by owner, real estate rentals in Mundy, and vacation homes Mundy
Apartment rentals West Bloomfield and West Bloomfield Michigan real estate rentals
For rent by owner homes in Lyon Michigan, rental apartment Lyon Michigan, and Lyon rental houses
Houses for rent in Georgetown Michigan, homes for rent by owner in Georgetown Michigan, short term rentals in Georgetown, and rental apartment Georgetown Michigan
Cadillac Michigan home rentals and homes for rent in Cadillac
Homes for rent in Birmingham, Birmingham Michigan rent houses, and condo rentals Birmingham Michigan
Home rentals, condo rentals Owosso Michigan, condos for rent, and bed and breakfast rentals in Owosso Michigan
Condos for rent in Plainfield and Plainfield short term rentals
Berkley holiday rentals, Berkley Michigan rental home, and vacation rentals in Berkley Michigan
Houses for rent Macomb Michigan, rental properties, Macomb Michigan rental apartment, and rental home Macomb
Detroit Michigan rental homes and apartment rentals Detroit
Real estate rentals, West Bloomfield Michigan condos for rent, and West Bloomfield Michigan rental home
Apartments for rent in Monroe Michigan, apartments for rent, rental houses in Monroe Michigan, and house rentals Monroe Michigan
Rent house in Mount Clemens Michigan and rental houses in Mount Clemens Michigan
House rentals, real estate rentals in Wayne Michigan, and homes for rent by owner Wayne
Southfield Michigan rental home, Southfield Michigan short term rentals, homes for rent by owner in Southfield Michigan, and vacation homes in Southfield Michigan
Bed and breakfast rentals and Lincoln Park Michigan rental properties
Short term rentals in Port Huron, homes for rent in Port Huron Michigan, and vacation rental Port Huron
Rental apartment, South Lyon Michigan rent house, South Lyon rent house, and rental properties South Lyon Michigan
Rental homes in Holly and Holly Michigan condo rentals
Rental apartment in Ypsilanti Michigan, apartment rentals Ypsilanti, and Ypsilanti Michigan real estate rentals
Vacation rentals East Grand Rapids Michigan, houses for rent in East Grand Rapids Michigan, homes for rent by owner East Grand Rapids Michigan, and condos for rent East Grand Rapids Michigan
Grand Rapids charter apartments for rent and Grand Rapids charter apartment rentals
Light upon discrete and singular facts in Hartland and run down rental properties in Hartland.
The Hartland Michigan lakeside listed properties and romantic advertisements for these principality can be mapped.
Our website, FRBO.com encloses square, field, tract, and block dope, not seldom.
Light upon and glimpse apartments for rent and Rollin United States rent houses.
Move, conceive, and perceive condo rentals in Van Buren Michigan, Van Buren Michigan for rent by owner homes, and Van Buren Michigan rental houses.
Invent and identify Stanwood apartments for rent and Stanwood United States for rent by owner homes.
Learn, perceive, and identify condos for rent in Livingston Michigan, vacation rentals in Livingston Michigan, Livingston Michigan home rentals, and Livingston Michigan vacation homes.
Find out, discern, and invent Otsego Michigan rent house, apartment rentals in Otsego Michigan, condo rentals Otsego Michigan, and homes for rent by owner in Otsego.
Recognize and recognize rental home in Lenawee Michigan and apartments for rent.
List and secure on Saturday to embark on, begin, originate, and inaugurate on this march.
Observe, notice, and find vacation rentals and houses for rent.
Observe and discover homes for rent by owner Clarksville United States and house rentals Clarksville.
Observe and identify rent houses and rent house in Ovid United States.
The Hartland Michigan ad directories buttoned down and kept counted on our for rent by owner website exclude decadent timeshare, well appointed home, secluded house, and exclusive apartment.
Grooms, honeymooners, and speculators who are looking Hartland Michigan apartments for rent and are trying to discern Hartland Michigan apartment rentals and bed and breakfast rentals can explore our for rent by owner site, FRBO.com and our well appointed classified ads, lakefront classified advertisements, penthouse listings, and convenient directories.
Perceive, uncover, and light upon holiday rentals Manistee Michigan and rental properties.
Using this extensive website, FRBO.com, condo owners itemize bungalow and house advertisements.
Ski in/out ads and penthouse online MLS apartments for rent in Chippewa, real estate rentals Chippewa, Chippewa rent houses, and house rentals Chippewa.
Detect and hear vacation rentals in Whittemore United States and Whittemore rental houses.
Notice, find, and discern Coleman rental home, Coleman United States apartment rentals, and homes for rent in Coleman.
Espy and identify Kaleva United States rental home and Kaleva real estate rentals.
Espy, hear, and elicit vacation rental, Calumet United States house rentals, and condos for rent in Calumet United States.
Explore, ferret out, and identify short term rentals Posen, rent house Posen, and real estate rentals.
We dreamed up and formed this website, FRBO.com to be shapely, superb, and admirable.
Chicago Illinois house rentals, Chicago Illinois rental houses, rental apartment in Chicago, and short term rentals in Chicago Illinois
Hartland Michigan is a divine, superb, sightly, and ideal block with good-looking, grand, handsome, and delightful villa, farmhouse, and houseboats.
Hear and conceive Port Huron United States holiday rentals and Port Huron holiday rentals.
Determine, recognize, and look up Burton United States condo rentals, vacation rentals Burton, and Burton rental home.
Find out and observe apartment rentals in Tuscola, Tuscola Michigan short term rentals, and Tuscola Michigan rental properties.
Conceive and notice rent house in Monroe Michigan, Monroe apartments for rent, for rent by owner homes in Monroe, and vacation homes in Monroe Michigan.
Adrian Michigan vacation rental and bed and breakfast rentals in Adrian
Come upon and perceive bed and breakfast rentals Macomb Michigan, rental houses Macomb Michigan, home rentals in Macomb Michigan, and house rentals.
Identify, conceive, and look up rental apartment in Oakley, rental houses in Oakley United States, and Oakley United States condos for rent.
|
|
