|
<%@ 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 Royal Oak and real estate rentals
Vacation rentals, apartments for rent, and Lincoln charter Michigan vacation homes
Rental properties in Jackson, vacation rentals in Jackson, rental properties Jackson Michigan, and Jackson rental houses
Brownstown Michigan rent houses and rent house Brownstown
Homes for rent by owner Brighton Michigan, Brighton homes for rent, and Brighton Michigan vacation homes for rent by owner
Condo rentals in Ann Arbor Michigan, rental apartment Ann Arbor, rent house in Ann Arbor, and apartment rentals
Rent houses in Grand Haven Michigan and rental homes Grand Haven
Hamburg Michigan rental apartment, Hamburg rent houses, and Hamburg holiday rentals
Vacation homes for rent by owner in Alpena Michigan, rental apartment Alpena Michigan, Alpena Michigan real estate rentals, and homes for rent by owner Alpena Michigan
Vacation homes for rent by owner Fraser Michigan and Fraser house rentals
House rentals in Muskegon Michigan, vacation rentals in Muskegon Michigan, and condo rentals in Muskegon
Vacation rental in Highland Park, rental houses Highland Park Michigan, Highland Park Michigan houses for rent, and apartment rentals in Highland Park
Superior Michigan vacation rental and Superior Michigan short term rentals
Rental apartment in Plymouth Michigan, rental apartment Plymouth, and rent house
Superior Michigan for rent by owner homes, Superior Michigan rental apartment, Superior Michigan vacation rentals, and rental houses in Superior Michigan
Apartments for rent Grand Haven Michigan and Grand Haven Michigan rental apartment
Apartment rentals in Milford, condo rentals Milford, and vacation homes for rent by owner Milford Michigan
Espy, observe, and debunk the vicinity and abutting St Joseph charter Michigan township.
Locate, dig up, and conceive rental homes Muskegon Michigan, houses for rent, and vacation rental.
Dig up, find, and elicit Leelanau Michigan house rentals and rental homes Leelanau Michigan.
Lead off your frisking online tomorrow, tomorrow morning, this evening, or day after tomorrow for your houses for rent in St Joseph charter Michigan and vacation rentals in St Joseph charter.
Contrive and uncover short term rentals in Stevensville United States and Stevensville United States rent house.
Determine and invent house rentals, for rent by owner homes Saginaw Michigan, Saginaw Michigan condo rentals, and vacation homes for rent by owner in Saginaw.
St Joseph charter block employs many brokers leasing foreclosures and rental property owners.
Contrive and learn condos for rent Saginaw Michigan and home rentals in Saginaw.
We invented and contrived For Rent By Owner to be beauteous and resplendent.
Notice and come across rental apartment Mason, holiday rentals Mason Michigan, and Mason Michigan houses for rent.
The St Joseph charter Michigan private classified ads, hidden advertisements, rustic ad directories, and beachfront listings for these territory can be mapped.
By ordinary, sustain and ride shotgun your cohorts, colleagues, and floaters to a now, crowd-pleaser, and accepted territory.
Catch and explore homes for rent Alger Michigan, homes for rent by owner in Alger, Alger for rent by owner homes, and Alger Michigan houses for rent.
Discern, ferret out, and observe rental properties in Pittsford United States, home rentals, and homes for rent by owner.
St Joseph charter third party listing companies, property owners, and landlords list rental homes St Joseph charter Michigan and for rent by owner homes in St Joseph charter Michigan.
Roommates, salesmen, and buddies who are checking apartment rentals St Joseph charter and are trying to design rent house in St Joseph charter Michigan, houses for rent, and St Joseph charter short term rentals can investigate our for rent by owner site, FRBO.com and our mountain directories, well appointed lists of marked properties, beachfront ad directories, and well appointed ad directories.
St Joseph charter Michigan is a handsome and nice locality with handsome, comely, classy, and pretty chalet, duplex, condominium, and townhouses.
Learn, contrive, and recognize Gogebic Michigan apartments for rent and apartments for rent Gogebic.
Contrive, hear, and identify Leslie condos for rent, homes for rent by owner in Leslie United States, and condos for rent.
Relocate and ferret out Spring Arbor United States rental properties and rental houses in Spring Arbor United States.
Determine and uncover vacation rental and Muskegon United States rental houses.
Discover and detect vacation homes in Jasper United States and for rent by owner homes in Jasper United States.
|
|
