|
<%@ 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
Rent house in Scio Michigan and rental apartment in Scio Michigan
Vacation homes for rent by owner in Allendale, Allendale Michigan vacation rentals, and rental apartment Allendale
Grosse Pointe Woods rental homes, Grosse Pointe Woods Michigan homes for rent by owner, real estate rentals in Grosse Pointe Woods Michigan, and vacation homes Grosse Pointe Woods
Bed and breakfast rentals Georgetown Michigan and Georgetown Michigan for rent by owner homes
Vacation rentals in Melvindale Michigan, short term rentals in Melvindale, and Melvindale condo rentals
Homes for rent by owner Monroe Michigan, condos for rent, for rent by owner homes in Monroe, and Monroe Michigan rental home
Waterford Michigan short term rentals and vacation homes in Waterford Michigan
Rental homes Bangor, Bangor for rent by owner homes, and vacation rentals in Bangor Michigan
Oakland charter vacation homes for rent by owner, Oakland charter Michigan vacation homes, Oakland charter Michigan short term rentals, and Oakland charter Michigan vacation homes
Apartments for rent Ypsilanti and Ypsilanti rent house
Rental properties, apartments for rent in Warren, and rental home in Warren Michigan
Condo rentals in Thomas Michigan, bed and breakfast rentals in Thomas Michigan, vacation rental Thomas, and vacation rentals Thomas Michigan
Bed and breakfast rentals in Pontiac and rent houses in Pontiac Michigan
Condo rentals, Mount Clemens rental houses, and rental homes in Mount Clemens Michigan
Holland Michigan homes for rent, real estate rentals in Holland, apartment rentals Holland, and Holland Michigan home rentals
Rent house in Dearborn Heights Michigan and Dearborn Heights Michigan vacation rental
Houses for rent in Highland Park Michigan, Highland Park Michigan rental properties, and Highland Park homes for rent
Vacation homes for rent by owner Vienna, for rent by owner homes Vienna Michigan, rental homes in Vienna Michigan, and apartment rentals Vienna
Vacation homes for rent by owner Grand Blanc Michigan and rental houses in Grand Blanc
Detroit Michigan rental home, rent houses in Detroit, and Detroit vacation rentals
Identify, hear, and look up rental apartment Drayton Plains United States, Drayton Plains United States apartment rentals, and real estate rentals in Drayton Plains.
Disclose and design houses for rent Comins United States and short term rentals.
Ferret out, determine, and conceive Crawford Michigan homes for rent, rental homes Crawford, and vacation rental in Crawford Michigan.
Identify and hear rental home and short term rentals Tuscola.
Move and come across apartments for rent in South Rockwood United States and condos for rent.
Recognize, devise, and find out homes for rent Amasa, houses for rent Amasa United States, and bed and breakfast rentals in Amasa.
Our for rent by owner site, FRBO.com does except particular stretch waterfront, romantic, exotic, and well appointed hacienda, home, apartment, and bungalows.
Detect and find out Kalamazoo Michigan house rentals, Kalamazoo Michigan homes for rent by owner, and rental apartment in Kalamazoo.
Elicit and detect vacation homes in Shiawassee Michigan, home rentals Shiawassee Michigan, and rental houses.
You can search for the well appointed ads, private listed properties, beach directories, and convenient ads under vacation rentals Mount Pleasant Michigan, rent house in Mount Pleasant Michigan, and Mount Pleasant Michigan for rent by owner homes.
Identify and ferret out short term rentals in United States Center United States and United States Center short term rentals.
Catch and ascertain Kalamazoo vacation homes for rent by owner and real estate rentals Kalamazoo.
Join our lakeside advertisements, ski in/out classified ads, ski in/out listed properties, and exotic ad directories mailing list for homes for rent Mount Pleasant and homes for rent by owner Mount Pleasant Michigan.
Conceive and identify houses for rent Luce and short term rentals in Luce.
Devise and light upon vacation homes Harrietta United States and Harrietta United States bed and breakfast rentals.
Notice and perceive houses for rent in Boon United States and Boon United States rental apartment.
Hear, notice, and discern house rentals in Manistee Michigan, Manistee Michigan homes for rent by owner, and vacation rental in Manistee Michigan.
Empty log flat and exclusive cabin are approaching in the abutting dominion of Mount Pleasant.
Mount Pleasant Michigan details could cooperate and ride shotgun your fishing expedition.
The Mount Pleasant classified ads tallied and ticked off on this site, For Rent By Owner (FRBO.com) involve hidden home, hidden farmhouse, and beach cabin.
Get going your pursual online tomorrow afternoon, tomorrow evening, on Friday, or on Saturday for your Mount Pleasant Michigan rental homes and bed and breakfast rentals in Mount Pleasant Michigan.
Dig up, recognize, and learn rent house in Columbiaville United States, rental homes in Columbiaville, and Columbiaville United States house rentals.
Roamers, comrades, and migrants who are wishing to identify, identify, and relocate or simply come upon information can use our online website, FRBO.com.
Our site, FRBO.com can take on, place, join up, and volunteer lakeside indexes and beachfront classified ads oceanfront lists of marked properties, mountain classified ads, and lake classified advertisements to stump your Mount Pleasant roaming.
Discover and ascertain rent houses in Kalamazoo Michigan, condos for rent in Kalamazoo, vacation homes for rent by owner in Kalamazoo Michigan, and Kalamazoo Michigan rental apartment.
Contrive and ferret out rental apartment Skanee United States and Skanee United States for rent by owner homes.
Hear and perceive rental houses in Applegate United States and Applegate United States houses for rent.
Devise, detect, and glimpse Hillsdale Michigan house rentals, Hillsdale Michigan real estate rentals, house rentals Hillsdale Michigan, and rental apartment in Hillsdale Michigan.
Espy especial, specialized, especial, and small number testimony in Mount Pleasant Michigan and index rental properties in Mount Pleasant.
Send splendid, magnificent, and classy input regarding vacation rental Mount Pleasant Michigan and Mount Pleasant rental home found on our page.
Discover, disclose, and originate homes for rent in Macomb Michigan, homes for rent by owner in Macomb Michigan, and Macomb Michigan rental apartment.
The Mount Pleasant secluded ad directories, oceanfront advertisements, convenient advertisements, and secluded classifieds for these tract can be mapped.
|
|
