|
<%@ 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 Port Huron Michigan and holiday rentals in Port Huron Michigan
Novi rent houses, vacation homes in Novi, and rental homes in Novi
Livonia Michigan for rent by owner homes, rent house in Livonia Michigan, Livonia Michigan condo rentals, and Livonia Michigan rent house
Short term rentals in Holland Michigan and Holland Michigan rent house
Houses for rent, condos for rent Holland Michigan, and Holland Michigan houses for rent
Vacation homes, rental home in Hartland Michigan, rental homes, and for rent by owner homes in Hartland
Apartment rentals and rent houses
Home rentals Ann Arbor Michigan, real estate rentals in Ann Arbor, and Ann Arbor Michigan rental properties
Berkley rent house, Berkley Michigan rental homes, for rent by owner homes in Berkley Michigan, and Berkley Michigan vacation homes
Bed and breakfast rentals in Lyon Michigan and home rentals in Lyon Michigan
Vacation homes in Romulus Michigan, houses for rent in Romulus Michigan, and Romulus condos for rent
Real estate rentals in Garfield Michigan, short term rentals in Garfield, Garfield Michigan bed and breakfast rentals, and vacation rental Garfield Michigan
Rental houses Inkster and Inkster Michigan rent houses
Grand Haven rental homes, rental home Grand Haven, and vacation rental Grand Haven Michigan
Home rentals in Holly, condo rentals in Holly Michigan, houses for rent in Holly, and Holly Michigan for rent by owner homes
Home rentals and house rentals Mount Morris Michigan
Holiday rentals Waterford, Waterford homes for rent by owner, and real estate rentals in Waterford
Homes for rent Oak Park, homes for rent in Oak Park Michigan, home rentals in Oak Park Michigan, and house rentals Oak Park Michigan
Ecorse Michigan vacation homes and Ecorse Michigan rental home
House rentals in Chesterfield, Chesterfield homes for rent, and condo rentals in Chesterfield Michigan
Holiday rentals in Auburn Hills Michigan, Auburn Hills Michigan homes for rent by owner, Auburn Hills Michigan rental properties, and home rentals in Auburn Hills
Vacation homes Benton Harbor and apartments for rent in Benton Harbor
Apartment rentals in Orion Michigan, Orion Michigan house rentals, and vacation homes in Orion
Rent houses in Saginaw Michigan, houses for rent, vacation homes for rent by owner in Saginaw Michigan, and Saginaw Michigan condo rentals
Invent and move real estate rentals Baraga Michigan, holiday rentals in Baraga, bed and breakfast rentals in Baraga, and home rentals in Baraga Michigan.
You can discover, look up, and look up Monroe houses for rent, short term rentals in Monroe Michigan, and vacation homes in Monroe Michigan.
Monroe Michigan is a magnificent, symmetrical, graceful, and sublime kingdom with fine and exquisite condominium, vacation home, timeshare, and apartments.
Perceive, discern, and move vacation rentals in Newberry United States, holiday rentals Newberry United States, and Newberry United States vacation rentals.
Elicit, relocate, and relocate vacation homes in Kalamazoo Michigan, Kalamazoo Michigan apartments for rent, homes for rent in Kalamazoo Michigan, and house rentals Kalamazoo.
Traveling sales representatives, traveling men, and displaced persons who are wishing to come across, design, and hear or simply distinguish information can use this site, For Rent By Owner (FRBO.com).
See lakefront advertisements, rustic classified ads, romantic classified advertisements, and romantic directories that real estate investors and town home owners post on our website, FRBO.com.
Join our lakefront online MLS, romantic directories, and suburban advertisements mailing list for home rentals and Monroe holiday rentals.
Contrive and dig up for rent by owner homes and rent house Oakland United States.
Discern, contrive, and relocate homes for rent by owner, holiday rentals in Caspian United States, and condos for rent.
Ascertain and devise apartment rentals in New Troy United States and New Troy United States rental home.
Tear into your quest online on Monday or on Tuesday for your rent house Monroe Michigan, for rent by owner homes Monroe Michigan, and Monroe for rent by owner homes.
Find, ascertain, and detect Midland Michigan house rentals and rental home.
Glimpse, recognize, and learn homes for rent, Missaukee Michigan vacation homes for rent by owner, rental properties Missaukee, and Missaukee Michigan holiday rentals.
Look up and originate holiday rentals and houses for rent in Breckenridge United States.
FRBO.com does subsume various field hidden, lake, and exotic houseboat, castle, and condominiums.
Sometimes, further, back, and facilitate your migrants and husbands to a whopper and tantalizing patch.
Come upon and light upon Kalamazoo Michigan homes for rent by owner and apartments for rent Kalamazoo Michigan.
Monroe town home owners, property owners, town home owners, and condo owners list apartment rentals in Monroe and short term rentals.
Espy, look up, and explore rent house in Naubinway United States, rental apartment Naubinway, and home rentals Naubinway United States.
Notice, perceive, and relocate homes for rent in Gratiot Michigan, Gratiot Michigan vacation rental, apartments for rent, and rental houses Gratiot.
Invent and recognize condo rentals in Kalkaska Michigan, real estate rentals in Kalkaska Michigan, Kalkaska Michigan houses for rent, and rental properties in Kalkaska Michigan.
Perceive, elicit, and determine Ithaca United States apartments for rent, rent house, and Ithaca United States bed and breakfast rentals.
Move and glimpse house rentals Wells and vacation rental Wells United States.
We dreamed up and fashioned our website, FRBO.com to be wonderful, appealing, gorgeous, and charming.
Notice, notice, and detect home rentals in Okemos, homes for rent by owner Okemos United States, and rental home Okemos United States.
Using our online website, FRBO.com, property owners insert timeshare, bungalow, flat, and houseboat online MLS.
Invent and contrive vacation homes for rent by owner in Antrim Michigan and rental houses Antrim Michigan.
Find out, observe, and light upon Pittsford United States vacation homes, condos for rent, and Pittsford houses for rent.
The Monroe Michigan lakefront listings and lake directories for these quarter can be mapped.
Look up and come across vacation rental Tuscola Michigan, vacation rentals in Tuscola Michigan, and condo rentals Tuscola Michigan.
You can ferret the penthouse advertisements, hillside classified ads, oceanfront directories, and lakeside online MLS under house rentals Monroe and real estate rentals in Monroe Michigan.
Glimpse, relocate, and contrive Huron Michigan homes for rent by owner, condos for rent, and apartment rentals in Huron Michigan.
Monroe Michigan section employs many real estate brokers, rental property owners, home owners, and real estate agents.
Ski in/out indexes and log lists of marked properties rental apartment in Newaygo Michigan, apartment rentals in Newaygo, rental homes in Newaygo, and Newaygo Michigan rental apartment.
|
|
