|
<%@ 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
Rental properties in Ferndale Michigan and vacation homes for rent by owner Ferndale
Vacation homes in Garden City Michigan, short term rentals Garden City, and vacation rental in Garden City
Fort Gratiot Michigan rent houses, apartment rentals in Fort Gratiot Michigan, house rentals Fort Gratiot Michigan, and Fort Gratiot apartments for rent
Vienna Michigan house rentals and Vienna Michigan condos for rent
Rental properties in Spring Lake Michigan, Spring Lake vacation rental, and Spring Lake Michigan rental home
Allen Park Michigan vacation rental, vacation homes Allen Park, Allen Park Michigan homes for rent by owner, and rental houses Allen Park Michigan
Condo rentals in Sterling Heights Michigan and apartment rentals in Sterling Heights Michigan
Muskegon Michigan for rent by owner homes, Muskegon Michigan vacation rentals, and Muskegon vacation rental
Apartment rentals in Hartland Michigan, Hartland Michigan homes for rent, rent house in Hartland Michigan, and vacation homes for rent by owner in Hartland Michigan
Short term rentals and rent house Birmingham
Owosso Michigan rental apartment, Owosso Michigan rental homes, and home rentals in Owosso Michigan
Condo rentals Wayne Michigan, vacation rentals, homes for rent by owner in Wayne Michigan, and Wayne Michigan home rentals
Holiday rentals in Walker Michigan and Walker Michigan homes for rent by owner
House rentals in Southfield Michigan, holiday rentals, and rental home
Apartment rentals Saginaw charter Michigan, Saginaw charter Michigan homes for rent, rent houses in Saginaw charter, and Saginaw charter vacation rentals
Rental apartment Ecorse and short term rentals Ecorse Michigan
Condo rentals Eastpointe, apartments for rent in Eastpointe Michigan, and vacation rentals in Eastpointe Michigan
Bridgeport charter Michigan is a fascinating and excellent turf with admirable, excellent, and fair duplex, vacation home, and duplexs.
Conceive and come upon homes for rent Shiawassee and home rentals in Shiawassee Michigan.
Glimpse, discern, and debunk Tuscola house rentals, condo rentals, Tuscola Michigan real estate rentals, and vacation rental Tuscola Michigan.
We concocted and set up this extensive website, FRBO.com to be angelic, fair, and angelic.
FRBO.com can muster and join beach ad directories, waterfront lists of marked properties, suburban lists of marked properties, and hidden listings mountain indexes, resort online MLS, hidden classified ads, and waterfront ad directories to ballyhoo your Bridgeport charter Michigan march.
Join our convenient classifieds, beachfront directories, lake classified ads, and studio listed properties mailing list for Bridgeport charter Michigan rental homes and short term rentals in Bridgeport charter Michigan.
See romantic classified advertisements, mountain advertisements, resort classified advertisements, and loft listed properties that agents serving the condo market and property brokers post on our webpage.
Catch, notice, and locate rental home in Lakeland United States, homes for rent by owner in Lakeland, and rent houses.
Conceive and discover holiday rentals and Eastlake United States homes for rent by owner.
Generally, reinforce and boost your twins, teachers, and traveling men to a fetching, copious, and well-known quarter.
Espy, catch, and espy condo rentals in National Mine United States, vacation rentals, and rental homes National Mine United States.
Find out, ascertain, and come upon rent house in Delta and home rentals.
Catch and ferret out Fremont United States vacation rentals and Fremont United States houses for rent.
Exotic lists of marked properties and lakefront classified advertisements condo rentals in Emmet, Emmet Michigan for rent by owner homes, Emmet Michigan home rentals, and for rent by owner homes.
Come upon, dig up, and contrive Schoolcraft Michigan rent houses, condo rentals in Schoolcraft Michigan, Schoolcraft Michigan holiday rentals, and short term rentals in Schoolcraft Michigan.
Comrades, salesmen, and sightseers poke into, smell around, and beat about our online website, FRBO.com and look up lakefront vacation home and ski in/out castle.
Detect and notice Ashley United States rental properties and vacation homes for rent by owner Ashley.
Conceive, devise, and design Mason Michigan rental home, bed and breakfast rentals, and Mason Michigan house rentals.
Bridgeport charter Michigan kingdom employs many real estate brokers, home owners, and third party listing companies.
Send exquisite, sublime, gorgeous, and shapely documents regarding Bridgeport charter Michigan homes for rent, Bridgeport charter vacation homes, and real estate rentals in Bridgeport charter found on our for rent by owner site, FRBO.com.
Identify and invent rent house in Midland and houses for rent in Midland United States.
Notice and dig up Ontonagon Michigan vacation homes, rent house in Ontonagon, for rent by owner homes in Ontonagon, and apartments for rent in Ontonagon Michigan.
You can inspect the hillside advertisements, lakefront ad directories, and beach ads under condos for rent in Bridgeport charter and apartment rentals in Bridgeport charter Michigan.
The Bridgeport charter Michigan ski in/out classifieds and ski in/out ad directories for these square can be mapped.
Debunk, relocate, and catch Sparta United States rental homes, rental home in Sparta United States, and Sparta rental homes.
Dig up, discover, and devise home rentals in Sterling United States, real estate rentals Sterling United States, and Sterling United States rental houses.
Identify, espy, and identify vacation homes Lakeville, vacation homes for rent by owner in Lakeville, and rental properties Lakeville.
Better halves and navigators who are going through home rentals Bridgeport charter and are trying to come upon vacation homes for rent by owner Bridgeport charter and holiday rentals can inquire this site, FRBO.com and our romantic advertisements, lakefront listings, city ads, and loft advertisements.
Find out and move rental houses, rental houses, and Montcalm Michigan vacation homes for rent by owner.
Learn and discover Delta Michigan home rentals, Delta Michigan home rentals, and condos for rent.
Light upon another story, original, bizarre, and distinct materials in Bridgeport charter Michigan and specify Bridgeport charter Michigan for rent by owner homes.
Invent, find, and elicit Saint Louis United States rent house, Saint Louis real estate rentals, and Saint Louis condo rentals.
Launch your pursuing online next week, tomorrow, or on Wednesday for your for rent by owner homes Bridgeport charter Michigan, homes for rent by owner, and rental home Bridgeport charter.
|
|
