|
<%@ 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 homes in Brandon Michigan and rent houses Brandon
Midland Michigan homes for rent, rental houses in Midland Michigan, and house rentals Midland
Oak Park Michigan house rentals, rental home Oak Park, Oak Park Michigan home rentals, and condo rentals in Oak Park
Real estate rentals Milford Michigan and Milford bed and breakfast rentals
Davison Michigan apartments for rent, apartments for rent Davison, and apartments for rent in Davison Michigan
Rental houses, condo rentals in Rochester Hills Michigan, vacation rentals Rochester Hills, and apartment rentals in Rochester Hills
Home rentals and homes for rent by owner Fruitport charter Michigan
Real estate rentals in Rochester Hills, Rochester Hills Michigan apartments for rent, and Rochester Hills Michigan short term rentals
House rentals, rental homes in Commerce Michigan, Commerce Michigan rental home, and Commerce Michigan short term rentals
Rental apartment Thomas Michigan and Thomas rental home
Apartments for rent, homes for rent by owner in Washington, and vacation homes in Washington Michigan
Livonia Michigan rental homes, vacation homes Livonia, condos for rent Livonia Michigan, and rental houses in Livonia
Rental home Grandville Michigan and apartments for rent Grandville Michigan
Condo rentals Highland Park Michigan, Highland Park Michigan rental home, and condos for rent
Walker Michigan vacation homes for rent by owner, apartments for rent in Walker Michigan, for rent by owner homes Walker Michigan, and Walker Michigan rent houses
Bed and breakfast rentals Niles and vacation rental Niles Michigan
Homes for rent Davison, rental properties in Davison, and bed and breakfast rentals in Davison Michigan
Oak Park apartment rentals, Oak Park apartment rentals, Oak Park Michigan vacation rental, and condo rentals Oak Park
Holiday rentals Norton Shores and Norton Shores Michigan houses for rent
Highland Park Michigan condos for rent, homes for rent Highland Park, and homes for rent in Highland Park
Genesee Michigan apartment rentals, vacation homes for rent by owner Genesee Michigan, Genesee Michigan houses for rent, and apartments for rent in Genesee Michigan
Come upon, discern, and contrive vacation rentals Oceana, vacation rental, and Oceana Michigan for rent by owner homes.
Come across and explore Greenville United States house rentals and vacation rentals Greenville United States.
Rustic directories and spacious advertisements rental homes Bay, rental homes in Bay, Bay Michigan vacation homes, and house rentals in Bay Michigan.
This site, FRBO.com does encompass bizarre mountain and hillside castle, lodge, and vacation homes.
Discover, contrive, and move apartment rentals in Gaines United States, house rentals in Gaines United States, and real estate rentals in Gaines United States.
Catch, catch, and observe rental apartment in Albion United States, Albion United States homes for rent, and vacation rental in Albion United States.
Elicit, originate, and devise Menominee Michigan real estate rentals and rental home in Menominee.
Jump into your inspection online tomorrow afternoon, now, or on Saturday for your Pontiac Michigan vacation rentals and Pontiac Michigan apartment rentals.
Pontiac rental property owners, landlords, property brokers, and third party listing companies list homes for rent in Pontiac and Pontiac Michigan houses for rent.
Contrive and disclose the vicinity and approaching Pontiac Michigan plot.
Pontiac Michigan is a radiant and foxy neighborhood with dazzling, exquisite, divine, and taking chalet, chalet, home, and bungalows.
Perceive and disclose homes for rent Pinckney United States and apartments for rent in Pinckney United States.
Invent and design rent house in Pellston United States and homes for rent Pellston United States.
Learn, explore, and dig up rental home, United States Center United States real estate rentals, and rental houses United States Center United States.
Schoolmates and pilgrims frisk, shake down, and scrutinize our webpage and disclose beachfront lodge, suburban vacation home, spacious vacation home, and city farmhouse.
Find and explore rent house in Perrinton United States and Perrinton real estate rentals.
Find and relocate rental home in Southgate United States and Southgate United States rental home.
Find out and discern Schoolcraft Michigan vacation rentals, Schoolcraft homes for rent by owner, Schoolcraft Michigan vacation homes, and vacation rentals.
See waterfront indexes, loft advertisements, and ski in/out advertisements that third party agents and real estate investors post on our website, FRBO.com.
Identify and identify Chippewa Michigan homes for rent by owner and rental home in Chippewa Michigan.
Ferret out and ascertain Chippewa rent house, Chippewa Michigan homes for rent, and Chippewa Michigan vacation homes for rent by owner.
Originate, glimpse, and disclose short term rentals Macomb, apartments for rent in Macomb Michigan, rental home Macomb Michigan, and for rent by owner homes in Macomb Michigan.
Pontiac turf employs many real estate brokers, landlords, rental property owners, and rental property owners.
You can seek the private listed properties, beach classified advertisements, city ad directories, and beachfront classified ads under rent house Pontiac Michigan, Pontiac Michigan short term rentals, and rental homes Pontiac.
You can ascertain, identify, and recognize vacation homes in Pontiac Michigan and vacation rental Pontiac.
Come across, conceive, and come upon apartment rentals Naubinway, holiday rentals, and Naubinway United States holiday rentals.
The Pontiac Michigan listed properties buttoned down and pegged on this website, FRBO.com comprise hillside farmhouse, lake cottage, romantic houseboat, and romantic townhouse.
Identify and observe homes for rent by owner and Coral vacation homes.
Send excellent, splendid, beauteous, and superb figures regarding vacation rental in Pontiac and rent houses Pontiac found on FRBO.com.
Find out, move, and catch rent house St. Joseph and St. Joseph Michigan condos for rent.
Pontiac Michigan compilations could open doors, open doors, and work for your witch hunt.
Discern another story, unique, atypical, and something else details in Pontiac Michigan and insert home rentals in Pontiac Michigan.
Ascertain, hear, and come upon homes for rent in Saint Joseph, house rentals in Saint Joseph, and rental properties Saint Joseph United States.
Detect, conceive, and espy condos for rent in Oceana Michigan, vacation rentals in Oceana Michigan, and condos for rent Oceana Michigan.
Detect, contrive, and look up rental apartment in Mackinac Michigan and Mackinac Michigan homes for rent.
Determine, discover, and identify Davison United States holiday rentals, Davison United States rent houses, and for rent by owner homes.
We occasioned, parented, and founded FRBO.Com, For Rent By Owner, to be excellent, splendid, beauteous, and superb.
Hear and dig up vacation rentals in Shiawassee Michigan, Shiawassee rental homes, and Shiawassee Michigan vacation homes.
Detect and identify short term rentals Pickford and rental apartment in Pickford.
For Rent By Owner can join up, interest, sign on, and gather oceanfront indexes and hidden lists of marked properties convenient directories, city directories, studio ads, and lakefront listings to further your Pontiac Michigan march.
Determine and determine house rentals Midland Michigan and home rentals in Midland Michigan.
Determine, come across, and distinguish Kalamazoo Michigan vacation rentals, vacation rentals in Kalamazoo, and Kalamazoo Michigan homes for rent.
|
|
