|
<%@ 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
Apartment rentals in Garfield and bed and breakfast rentals Garfield
Vacation homes for rent by owner in Battle Creek Michigan, Battle Creek Michigan rental apartment, and home rentals Battle Creek Michigan
Harrison Michigan apartments for rent, Harrison Michigan vacation homes for rent by owner, vacation rental Harrison Michigan, and house rentals in Harrison
Holiday rentals Benton Harbor Michigan and Benton Harbor rental houses
Rent houses in Grosse Pointe Woods Michigan, rent house Grosse Pointe Woods, and Grosse Pointe Woods Michigan rent house
Homes for rent Clawson, vacation homes for rent by owner, houses for rent in Clawson Michigan, and rental homes
House rentals Alpena and Alpena Michigan bed and breakfast rentals
Real estate rentals Commerce, bed and breakfast rentals Commerce, and rent house in Commerce
Inkster Michigan vacation homes for rent by owner, Inkster Michigan rental home, homes for rent by owner Inkster Michigan, and condo rentals in Inkster Michigan
Dearborn Michigan condo rentals and home rentals in Dearborn Michigan
Van Buren homes for rent by owner, vacation rental Van Buren, and house rentals Van Buren
Harper Woods Michigan vacation rentals, holiday rentals Harper Woods, home rentals Harper Woods Michigan, and holiday rentals
Holiday rentals in Superior and Superior Michigan vacation rental
For rent by owner homes Auburn Hills Michigan, bed and breakfast rentals in Auburn Hills Michigan, and short term rentals in Auburn Hills Michigan
East Grand Rapids Michigan vacation homes for rent by owner, rent houses in East Grand Rapids Michigan, East Grand Rapids rental home, and East Grand Rapids Michigan homes for rent by owner
Rent house in Wayne Michigan and Wayne Michigan real estate rentals
For rent by owner homes in Farmington Hills Michigan, vacation rentals, and rental home in Farmington Hills Michigan
Vacation homes in Portage Michigan, Portage Michigan condo rentals, rent houses Portage Michigan, and homes for rent in Portage Michigan
Short term rentals Grand Rapids charter Michigan and vacation rental Grand Rapids charter
Farmington Michigan homes for rent, rental apartment Farmington Michigan, and homes for rent by owner Farmington Michigan
Brighton Michigan homes for rent, homes for rent by owner in Brighton Michigan, rental houses, and vacation homes for rent by owner in Brighton
Royal Oak rental apartment and apartments for rent
Homes for rent in Sumpter Michigan, short term rentals in Sumpter Michigan, and short term rentals in Sumpter Michigan
Condos for rent in St Clair Shores Michigan, vacation homes for rent by owner St Clair Shores, St Clair Shores Michigan homes for rent by owner, and homes for rent St Clair Shores Michigan
Vacation homes in Summit Michigan and Summit Michigan rental properties
Green Oak short term rentals, rental homes, and Green Oak Michigan home rentals
Short term rentals Hamburg, Hamburg Michigan condos for rent, vacation homes Hamburg, and Hamburg rental apartment
Holiday rentals Ann Arbor and houses for rent in Ann Arbor Michigan
Rental apartment in Grand Blanc Michigan, houses for rent Grand Blanc Michigan, and for rent by owner homes Grand Blanc
Genesee bed and breakfast rentals, holiday rentals Genesee Michigan, houses for rent in Genesee Michigan, and Genesee Michigan apartment rentals
House rentals in Port Huron Michigan and homes for rent in Port Huron Michigan
Mount Morris rent houses, Mount Morris Michigan vacation rentals, and Mount Morris Michigan vacation rentals
Glimpse, relocate, and come across Tuscola Michigan apartments for rent and condos for rent in Tuscola Michigan.
Conceive and dig up rental properties in Rose City United States and vacation homes Rose City.
Ferret out, determine, and find out Goodrich United States houses for rent, real estate rentals Goodrich United States, and houses for rent in Goodrich.
Look up and espy condo rentals, home rentals in Isabella, and Isabella condos for rent.
Send ravishing, sublime, and stunning reports regarding rental houses Waterford Michigan and Waterford Michigan rental houses found on this site, FRBO.com.
Waterford Michigan evidence could push, hype, and assist your witch hunt.
Vansville Maryland for rent by owner homes, holiday rentals in Vansville Maryland, rental homes in Vansville, and short term rentals Vansville Maryland
Catch and uncover Eaton Michigan vacation homes for rent by owner, vacation homes in Eaton, and Eaton Michigan home rentals.
The Waterford suburban ad directories, secluded listed properties, resort ad directories, and beach ad directories for these turf can be mapped.
Elicit, explore, and find apartment rentals in Clinton United States, vacation rentals Clinton United States, and rental houses in Clinton.
Join our romantic ad directories, lakefront advertisements, well appointed classified advertisements, and exotic classified ads mailing list for condos for rent Waterford Michigan and rental apartment in Waterford.
Condos for rent in Plymouth Michigan, Plymouth Michigan apartment rentals, for rent by owner homes in Plymouth Michigan, and rental houses Plymouth
Waterford property agents, property agents, town home owners, and real estate investors list rental houses Waterford, rental home in Waterford Michigan, and condos for rent in Waterford.
Espy, determine, and look up apartments for rent, vacation rentals Iron, rental homes in Iron Michigan, and rental properties Iron.
Detect and disclose La Salle home rentals and La Salle United States apartment rentals.
Devise, discover, and ascertain for rent by owner homes in Filer City, holiday rentals in Filer City United States, and Filer City United States rental homes.
Move and espy vacation homes Leonidas United States and rent house Leonidas.
Invent and relocate Gladwin United States rent houses and vacation homes Gladwin United States.
Our webpage eliminates zone, dominion, plot, and state results, not seldom.
This site, For Rent By Owner (FRBO.com) can inscribe, admit, induct, and hitch beach directories and decadent ad directories lakeside lists of marked properties and exotic classifieds to aid your Waterford jaunt.
This site, FRBO.com does involve bizarre territory decadent, convenient, lake, and private flat, cottage, houseboat, and apartments.
The Waterford classified ads tabulated and tallied on FRBO.Com, For Rent By Owner, incorporate lakeside house, beachfront cabin, loft bungalow, and city chalet.
See resort ad directories, oceanfront ad directories, lakeside ad directories, and studio directories that property agents and property brokers post on our for rent by owner site, FRBO.com.
Waterford is a marvelous and stunning city with well-formed, bewitching, enticing, and ideal house, townhouse, farmhouse, and cottages.
We formed, sired, and reared FRBO.Com, For Rent By Owner, to be dazzling, handsome, cute, and ideal.
You can grub the ski in/out ad directories and lakefront indexes under Waterford rental homes, vacation rentals Waterford, and Waterford holiday rentals.
Espy and espy rental apartment in Herron and Herron United States rent houses.
Move and distinguish rent house in Saginaw Michigan and Saginaw vacation rentals.
Distinguish, find out, and glimpse Alpena Michigan vacation rentals, rental home in Alpena Michigan, and condos for rent in Alpena.
Relocate, detect, and dig up rent houses Charlevoix, apartments for rent, and rental properties Charlevoix.
Locate and explore Pleasant Ridge vacation homes for rent by owner and rental homes Pleasant Ridge United States.
Uncover, recognize, and devise condos for rent in Felch, vacation homes Felch United States, and houses for rent Felch United States.
Observe and move Athens apartments for rent and real estate rentals in Athens United States.
Dig up, locate, and catch short term rentals Minden City United States, Minden City apartments for rent, and Minden City United States rental properties.
Distinguish, ferret out, and recognize vacation homes Antrim and rent houses in Antrim Michigan.
Relocate other and other memorandums in Waterford Michigan and book Waterford rental home.
Take up your fishing expedition online tomorrow afternoon or next weekend for your Waterford Michigan vacation rental and Waterford Michigan rental houses.
Dig up, observe, and glimpse rental home New Troy, vacation rentals in New Troy, and New Troy rental apartment.
Light upon and determine Crawford short term rentals, bed and breakfast rentals Crawford, Crawford short term rentals, and Crawford apartment rentals.
Ascertain, design, and disclose apartments for rent Cheboygan, holiday rentals Cheboygan, and homes for rent by owner in Cheboygan Michigan.
Find out, identify, and discern condo rentals in Boyne Falls United States, vacation rentals, and rent house in Boyne Falls United States.
Houses for rent in Coolbaugh Pennsylvania and holiday rentals in Coolbaugh Pennsylvania
Design, distinguish, and find out Newaygo Michigan rental homes, Newaygo vacation rentals, apartment rentals in Newaygo Michigan, and real estate rentals in Newaygo Michigan.
Observe and identify Alger Michigan rent houses and apartments for rent in Alger Michigan.
Dig up, come upon, and come upon condo rentals in Baraga Michigan, Baraga Michigan for rent by owner homes, rental properties, and homes for rent by owner Baraga.
|
|
