|
<%@ 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
Vacation rentals in Cannon and Cannon Michigan homes for rent by owner
Vacation rentals in Alpena Michigan, rental houses Alpena Michigan, and Alpena Michigan rental apartment
Condo rentals, rental home in Orion Michigan, rent houses in Orion Michigan, and Orion Michigan apartments for rent
Apartments for rent Sturgis Michigan and home rentals in Sturgis Michigan
Vacation rentals St Clair Shores, St Clair Shores Michigan homes for rent, and short term rentals St Clair Shores
Short term rentals White Lake, White Lake Michigan condo rentals, rental homes White Lake Michigan, and White Lake Michigan rent house
Vacation homes in Coldwater Michigan and house rentals
Rent house, holiday rentals in Bedford Michigan, and rental houses in Bedford Michigan
Rental properties Grand Rapids charter Michigan, Grand Rapids charter Michigan vacation rentals, condo rentals in Grand Rapids charter Michigan, and Grand Rapids charter real estate rentals
Rental apartment in Ferndale Michigan and Ferndale vacation homes
Vacation rentals in Cannon Michigan, Cannon Michigan rental apartment, and vacation homes for rent by owner
Saginaw apartment rentals, condos for rent in Saginaw Michigan, condos for rent, and vacation homes in Saginaw Michigan
Vacation rental Kentwood and bed and breakfast rentals in Kentwood
Rental homes, for rent by owner homes, and vacation rental in Southfield
Vacation rentals in Davison Michigan, short term rentals in Davison Michigan, Davison Michigan rental houses, and vacation homes in Davison Michigan
House rentals East Grand Rapids and East Grand Rapids condo rentals
Rent houses Fenton Michigan, for rent by owner homes in Fenton Michigan, and rent houses in Fenton Michigan
Short term rentals, rental home in Eastpointe Michigan, holiday rentals, and vacation homes Eastpointe Michigan
Condos for rent in Sterling Heights Michigan and short term rentals Sterling Heights Michigan
Rent house in Bay City Michigan, Bay City Michigan house rentals, and bed and breakfast rentals in Bay City Michigan
Rental houses Benton charter Michigan, Benton charter Michigan rental home, Benton charter Michigan rental apartment, and Benton charter Michigan short term rentals
Short term rentals in Georgetown Michigan and vacation rental in Georgetown
Vacation homes, Owosso houses for rent, and short term rentals in Owosso Michigan
Bed and breakfast rentals in Harrison, apartment rentals in Harrison Michigan, rental home, and Harrison apartments for rent
Battle Creek Michigan rent house and Battle Creek Michigan bed and breakfast rentals
Vacation rental Pontiac, Pontiac rent houses, and Pontiac Michigan rental home
Grosse Pointe Woods Michigan vacation homes, Grosse Pointe Woods Michigan vacation rentals, homes for rent Grosse Pointe Woods Michigan, and Grosse Pointe Woods Michigan short term rentals
Monitor Michigan rental apartment and short term rentals in Monitor
Rental properties in Fridley Minnesota, rental homes in Fridley Minnesota, short term rentals in Fridley Minnesota, and vacation homes for rent by owner in Fridley
Ascertain, explore, and originate Port Austin United States real estate rentals, Port Austin United States vacation homes, and Port Austin United States bed and breakfast rentals.
Identify, identify, and recognize rent house Almont United States, Almont United States condos for rent, and holiday rentals Almont United States.
Identify, come across, and identify Antrim Michigan rental houses, short term rentals in Antrim Michigan, and holiday rentals in Antrim Michigan.
Devise, ferret out, and identify rental properties in Bay Port United States, Bay Port rental houses, and holiday rentals Bay Port United States.
Recognize and debunk real estate rentals Mecosta and Mecosta United States short term rentals.
Join our well appointed directories, secluded lists of marked properties, beach classified advertisements, and romantic listings mailing list for rental apartment in Roseville Michigan and Roseville rental houses.
You can run down the exotic online MLS and exotic listings under homes for rent by owner in Roseville Michigan, rental homes, and Roseville home rentals.
Distinguish and move Cheboygan Michigan vacation rental and apartment rentals in Cheboygan Michigan.
Disclose extraordinary, unique, special, and specific brass tacks in Roseville Michigan and particularize Roseville Michigan rent house.
Perceive, locate, and notice condo rentals in Roscommon Michigan, Roscommon Michigan rental houses, Roscommon for rent by owner homes, and real estate rentals Roscommon Michigan.
The Roseville Michigan resort directories, studio lists of marked properties, beachfront lists of marked properties, and secluded classified advertisements for these section can be mapped.
Junketers, students, and coeds hunt, scout, and grub our online website, FRBO.com and detect penthouse vacation home, romantic house, penthouse home, and spacious vacation home.
Elicit, perceive, and catch the plot and adjacent Roseville Michigan dominion.
Perceive, ferret out, and identify Deckerville United States home rentals, apartment rentals in Deckerville, and Deckerville vacation rental.
Observe, determine, and uncover Alger Michigan home rentals and rental apartment in Alger Michigan.
Ascertain and determine vacation rentals in New Troy United States and bed and breakfast rentals in New Troy United States.
Roseville rental property owners, third party listing companies, home owners, and property managers list short term rentals in Roseville and Roseville Michigan home rentals.
Vacation homes for rent by owner and home rentals in Salina New York
Detect, come across, and espy rental homes Ontonagon, for rent by owner homes in Ontonagon Michigan, rental houses, and rental home Ontonagon.
Move and come upon houses for rent, Emmet rental houses, and vacation homes for rent by owner in Emmet.
Using our website, FRBO.com, agents keep count cottage, lodge, and castle directories.
You can detect and look up rental houses Roseville Michigan and Roseville Michigan rental properties.
Dig up and conceive real estate rentals in Lapeer Michigan and rent houses in Lapeer Michigan.
Invent and explore vacation homes for rent by owner Roscommon and Roscommon rental houses.
Friends and teachers who are wishing to discern and find or simply conceive information can use our online website, FRBO.com.
Our for rent by owner site, FRBO.com does enclose specialized turf lakefront, lake, hidden, and secluded cabin, houseboat, and townhouses.
We produced and phrased our website, FRBO.com to be grand, enticing, and graceful.
List, obtain, call up, and reserve this weekend to tear into, kick off, originate, and jump into on this pilgrimage.
Learn, find, and hear vacation homes for rent by owner in Emmet and for rent by owner homes in Emmet Michigan.
Espy, distinguish, and ascertain houses for rent in Crawford Michigan and holiday rentals.
Conceive and find Luther apartments for rent and vacation rental in Luther United States.
Discern and dig up rental apartment in Oak Park United States and Oak Park United States rent houses.
Espy and find out vacation homes and Melvindale United States home rentals.
Roseville Michigan is a resplendent, superb, and superb sector with beauteous, grand, ideal, and ideal apartment, townhouse, timeshare, and timeshares.
Send ravishing, sightly, lovely, and lovely documents regarding homes for rent by owner, homes for rent in Roseville Michigan, and rental houses Roseville found on this website, FRBO.com.
Periodically, stump, serve, and abet your navigators and itinerants to a notorious and stylish turf.
Discern and find out vacation homes in Ottawa and vacation rental in Ottawa.
Discern, find, and relocate vacation rental Eastlake, Eastlake United States homes for rent, and home rentals.
Get cracking your going-over online on Monday, tomorrow, or tomorrow evening for your Roseville Michigan rental homes and short term rentals.
Detect, learn, and detect vacation rentals Otsego, for rent by owner homes Otsego, and Otsego condo rentals.
See city advertisements, private indexes, and suburban lists of marked properties that home owners and town home owners post on our for rent by owner website.
Discover, observe, and notice Delta Michigan short term rentals, Delta apartments for rent, Delta Michigan rental properties, and house rentals in Delta.
Rental apartment East Sonora-Phoenix Lake and East Sonora-Phoenix Lake homes for rent
Identify and catch Calhoun Michigan vacation homes, short term rentals in Calhoun Michigan, and vacation homes in Calhoun.
|
|
