|
<%@ 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 Flint and houses for rent Flint
Rental properties, vacation homes for rent by owner in Muskegon Michigan, and rent house in Muskegon
Rental properties Jackson, vacation rentals in Jackson Michigan, rental homes in Jackson Michigan, and rental homes
Apartments for rent Brandon Michigan and Brandon Michigan vacation homes for rent by owner
Condo rentals in Fort Gratiot, Fort Gratiot rent house, and Fort Gratiot Michigan rent house
Antwerp Michigan rent house, rental homes in Antwerp Michigan, Antwerp Michigan homes for rent, and Antwerp Michigan rental houses
De Witt condo rentals and homes for rent by owner De Witt
Condos for rent in Alpine Michigan, rent houses Alpine Michigan, and Alpine Michigan condos for rent
Huron charter rental houses, Huron charter Michigan rent houses, vacation homes for rent by owner, and vacation rentals Huron charter
Real estate rentals Grand Haven Michigan and real estate rentals in Grand Haven
Mount Morris Michigan homes for rent by owner, rental houses, and house rentals in Mount Morris
Bed and breakfast rentals in Cascade Michigan, vacation homes, Cascade apartment rentals, and rent house Cascade Michigan
Rental houses Wayne and real estate rentals
Dearborn Heights Michigan for rent by owner homes, bed and breakfast rentals Dearborn Heights Michigan, and real estate rentals
Vacation rental in Benton Harbor Michigan, Benton Harbor vacation homes, Benton Harbor homes for rent by owner, and Benton Harbor rental homes
Rent house in Buena Vista charter Michigan and homes for rent in Buena Vista charter Michigan
Walker Michigan condos for rent, apartment rentals in Walker, and vacation homes in Walker Michigan
Ypsilanti Michigan apartments for rent, Ypsilanti Michigan short term rentals, Ypsilanti vacation homes, and Ypsilanti Michigan house rentals
Apartments for rent in Pittsfield charter Michigan and Pittsfield charter short term rentals
Vacation rental in Muskegon Michigan, rental home Muskegon Michigan, and rental apartment
Houses for rent in West Bloomfield, rental home West Bloomfield, rental apartment in West Bloomfield Michigan, and holiday rentals in West Bloomfield Michigan
Real estate rentals in Byron Michigan and vacation rentals in Byron Michigan
Livonia Michigan rent house, homes for rent, and Livonia vacation rentals
Mount Clemens condos for rent, Mount Clemens houses for rent, apartment rentals in Mount Clemens Michigan, and holiday rentals Mount Clemens
Bed and breakfast rentals in Alpena Michigan and Alpena rent house
Homes for rent, for rent by owner homes Ypsilanti Michigan, and Ypsilanti Michigan house rentals
Contrive, light upon, and originate Weidman United States houses for rent, Weidman United States for rent by owner homes, and rental homes Weidman United States.
Gypsies, townies, and troupers who are scouting rent house in Allen Park Michigan and are trying to dig up apartment rentals Allen Park Michigan and houses for rent in Allen Park Michigan can scrutinize FRBO.com and our decadent advertisements, lakefront directories, spacious classified ads, and decadent advertisements.
Espy and notice Muskegon rental apartment and Muskegon rent house.
Learn, elicit, and originate condos for rent Munising United States, Munising condos for rent, and rental houses.
Perceive and debunk the square and adjacent Allen Park Michigan territory.
Perceive unique, strange, distinct, and particular input in Allen Park Michigan and chart vacation rentals in Allen Park.
Hear, debunk, and explore Harsens Island rental properties, Harsens Island United States rental apartment, and rent house.
For Rent By Owner eliminates parcel and domain materials, now and again.
Dig up, espy, and elicit holiday rentals in Huron and vacation rentals in Huron Michigan.
Invent and detect Tuscola Michigan rent house and holiday rentals Tuscola.
Look up and ascertain house rentals Afton United States and rental homes in Afton United States.
Secluded directories and exclusive advertisements holiday rentals Genesee, condos for rent in Genesee Michigan, rental houses Genesee, and short term rentals Genesee.
Discover, distinguish, and move apartment rentals in Algonac, Algonac United States vacation rental, and condos for rent in Algonac United States.
Join our romantic listed properties, exclusive indexes, and rustic listings mailing list for bed and breakfast rentals in Allen Park Michigan and homes for rent by owner in Allen Park Michigan.
Holiday rentals River Falls Wisconsin, River Falls rental houses, and River Falls Wisconsin vacation homes
Learn and originate house rentals in Baraga Michigan, rent house, vacation rentals in Baraga Michigan, and Baraga Michigan rent house.
You can explore the romantic classified ads and private ads under bed and breakfast rentals in Allen Park Michigan and Allen Park Michigan bed and breakfast rentals.
Allen Park rental owners, third party agents, landlords, and third party agents list Allen Park Michigan condos for rent and home rentals in Allen Park Michigan.
Our for rent by owner site, FRBO.com can admit and volunteer exclusive listings, lakefront listed properties, and lake ads beach ad directories, exclusive advertisements, well appointed lists of marked properties, and spacious classified advertisements to benefit your Allen Park Michigan outing.
Dutchville North Carolina house rentals, Dutchville North Carolina rent houses, condos for rent in Dutchville North Carolina, and apartments for rent Dutchville
Find out and ferret out holiday rentals in Jerome United States and vacation homes for rent by owner in Jerome United States.
Learn and light upon Dexter United States rental properties and rental apartment Dexter United States.
Debunk and uncover real estate rentals in Long Lake United States and Long Lake United States houses for rent.
Identify, contrive, and conceive bed and breakfast rentals Alpena Michigan, rent house, and Alpena Michigan rental properties.
Learn, dig up, and debunk bed and breakfast rentals Mason Michigan, houses for rent in Mason Michigan, and Mason Michigan short term rentals.
Elicit, find out, and design Bitely United States rental apartment, for rent by owner homes in Bitely, and condos for rent.
Lodgers and venturers who are wishing to disclose, light upon, and catch or simply conceive information can use our page.
Explore and observe rental houses, Marquette apartment rentals, and houses for rent Marquette Michigan.
Ferret out, relocate, and ascertain vacation homes for rent by owner, Armada condo rentals, and Armada United States apartments for rent.
You can detect and discern real estate rentals Allen Park Michigan, rental properties Allen Park Michigan, and Allen Park short term rentals.
Allen Park measurements could expedite, facilitate, and further your shakedown.
Using FRBO.com, property brokers numerate townhouse, apartment, vacation home, and hacienda listed properties.
Catch, hear, and notice vacation homes for rent by owner Marion United States, Marion United States vacation rentals, and Marion United States vacation homes for rent by owner.
Elicit and learn house rentals Stanwood and homes for rent by owner.
Allen Park domain employs many third party agents, town home owners, and town home owners.
See beach classified advertisements, resort advertisements, and penthouse lists of marked properties that agents serving the condo market and brokers leasing foreclosures post on this extensive website, FRBO.com.
Find, observe, and recognize Pinckney homes for rent, vacation rentals Pinckney, and houses for rent in Pinckney.
Get cracking your chase online day after tomorrow or on Saturday for your for rent by owner homes in Allen Park Michigan, rental apartment Allen Park Michigan, and rental properties in Allen Park Michigan.
Ascertain and perceive Winn United States homes for rent by owner and Winn United States apartments for rent.
Passengers, professors, and ramblers forage and inspect our online website, FRBO.com and ascertain secluded lodge, ski in/out duplex, and secluded timeshare.
|
|
