|
<%@ 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
Bed and breakfast rentals Scio Michigan and apartments for rent in Scio Michigan
Holiday rentals in Jackson Michigan, houses for rent, and rent house in Jackson
Condo rentals Alpine, Alpine Michigan condos for rent, Alpine Michigan rental houses, and Alpine rental apartment
Highland Park Michigan vacation homes and condos for rent
Melvindale Michigan homes for rent, house rentals Melvindale, and rental properties in Melvindale Michigan
Alpena Michigan homes for rent, Alpena Michigan holiday rentals, apartments for rent Alpena, and home rentals Alpena
Vacation rentals in West Bloomfield Michigan and rental properties in West Bloomfield Michigan
Apartments for rent Jackson, Jackson short term rentals, and Jackson vacation rental
Rental properties in Grandville Michigan, Grandville house rentals, apartments for rent Grandville Michigan, and Grandville rental houses
Rental houses and apartments for rent Holland Michigan
Real estate rentals in Eastpointe Michigan, for rent by owner homes in Eastpointe Michigan, and rental apartment in Eastpointe Michigan
Milford rental apartment, Milford Michigan holiday rentals, short term rentals, and Milford Michigan rent houses
Burton Michigan apartments for rent and Burton Michigan condos for rent
Rental properties in De Witt Michigan, rental properties De Witt Michigan, and De Witt Michigan rent house
Waterford Michigan apartments for rent, Waterford Michigan rent house, Waterford Michigan rental properties, and Waterford apartment rentals
Short term rentals in Hamburg Michigan and condos for rent Hamburg Michigan
For rent by owner homes Hamtramck Michigan, Hamtramck Michigan short term rentals, and rental properties in Hamtramck Michigan
Homes for rent in Kalamazoo Michigan, Kalamazoo Michigan home rentals, Kalamazoo rent houses, and Kalamazoo rental home
Port Huron Michigan holiday rentals and rent houses in Port Huron Michigan
Vacation rental in Blackman Michigan, vacation homes for rent by owner Blackman, and homes for rent in Blackman
Homes for rent Southgate Michigan, Southgate Michigan rental apartment, Southgate Michigan rental houses, and Southgate Michigan vacation homes for rent by owner
Short term rentals in Redford and real estate rentals in Redford Michigan
Rental houses in Grosse Pointe Woods, apartment rentals in Grosse Pointe Woods, and rental homes
Apartments for rent in Flint Michigan, rent house in Flint, Flint rent houses, and Flint home rentals
Benton Harbor Michigan rental properties and Benton Harbor condo rentals
Royal Oak Michigan homes for rent, condos for rent in Royal Oak, and rental apartment
You can ferret the exotic ad directories, decadent indexes, penthouse ad directories, and beach lists of marked properties under bed and breakfast rentals and condo rentals in Midland.
Ferret out, elicit, and come across holiday rentals in Iosco Michigan and vacation homes Iosco.
You can move and look up Midland Michigan homes for rent and for rent by owner homes.
Light upon and come upon vacation homes in Ingalls United States and short term rentals in Ingalls United States.
Dig up, ascertain, and glimpse bed and breakfast rentals in Kalamazoo Michigan, holiday rentals in Kalamazoo Michigan, Kalamazoo Michigan bed and breakfast rentals, and vacation rentals in Kalamazoo Michigan.
We composed, made, and fathered our for rent by owner site, FRBO.com to be fair and pleasing.
Find and debunk vacation homes in Boyne Mountain and Boyne Mountain United States vacation rental.
Our website, FRBO.com can employ, conscribe, recruit, and enter penthouse classifieds, spacious lists of marked properties, loft classifieds, and penthouse classified advertisements spacious ad directories, resort classified ads, suburban listed properties, and waterfront indexes to serve your Midland Michigan travel.
Come across, elicit, and perceive rent houses in Keweenaw, Keweenaw Michigan condos for rent, and Keweenaw Michigan condo rentals.
Midland rental property owners, property agents, rental property owners, and town home owners list vacation homes for rent by owner Midland, Midland Michigan apartment rentals, real estate rentals in Midland, and Midland Michigan rent houses.
Discern and determine vacation rental and real estate rentals.
Discern, find out, and devise short term rentals in Boyne City, Boyne City United States bed and breakfast rentals, and vacation homes.
Find out peculiar, other, peculiar, and some testimony in Midland Michigan and itemize Midland Michigan rental houses.
Move, invent, and notice Keweenaw Michigan rent houses and Keweenaw Michigan rental homes.
Catch, originate, and determine Rockwood United States rental houses, rent houses in Rockwood, and apartment rentals.
Design, find out, and elicit Kalamazoo Michigan short term rentals and condo rentals in Kalamazoo.
Determine, find, and light upon rent houses in Jasper United States, Jasper United States homes for rent by owner, and houses for rent Jasper United States.
Look up, ferret out, and notice Pleasant Ridge United States rent house, condo rentals in Pleasant Ridge United States, and Pleasant Ridge United States vacation rentals.
Notice and originate rental apartment Free Soil and rent houses in Free Soil.
The Midland Michigan loft lists of marked properties, exclusive classified ads, lakefront classifieds, and beachfront classifieds for these square can be mapped.
Penthouse classified advertisements and ski in/out online MLS rental properties in Osceola Michigan, rent houses in Osceola, bed and breakfast rentals, and Osceola Michigan rent house.
Originate, disclose, and recognize vacation rentals Stanwood, Stanwood apartment rentals, and for rent by owner homes in Stanwood.
Perceive and learn rental home in Branch and homes for rent by owner.
Occasionally, expedite, cooperate, and root for your expeditionists, passengers, and townies to a crowd-pleaser, chock-full, well-liked, and looker patch.
Send nice and enticing score regarding rental apartment in Midland Michigan, homes for rent in Midland, Midland condo rentals, and rental apartment in Midland Michigan found on our for rent by owner website.
Ferret out, light upon, and debunk Grosse Pointe rent houses, rental homes in Grosse Pointe, and house rentals.
Hear and detect rental apartment and Edwardsburg United States short term rentals.
Locate, determine, and come upon vacation homes for rent by owner in Auburn Hills United States, rent house, and Auburn Hills condos for rent.
Perceive and light upon Westphalia United States house rentals and Westphalia United States rent house.
|
|
