|
<%@ 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 properties in Cascade Michigan and homes for rent by owner
Apartments for rent in Summit Michigan, rent house, and rental home in Summit
Vacation rental in Milford Michigan, holiday rentals in Milford, for rent by owner homes, and Milford Michigan vacation homes
Vacation rentals in Flint and Flint condos for rent
Escanaba Michigan for rent by owner homes, Escanaba Michigan condos for rent, and rental home
Bed and breakfast rentals in Sumpter, bed and breakfast rentals in Sumpter, Sumpter Michigan houses for rent, and Sumpter Michigan condo rentals
Rental houses in Summit Michigan and vacation homes Summit
Taylor Michigan condo rentals, Taylor homes for rent by owner, and Taylor rental home
Rental homes in Fraser Michigan, Fraser rent house, vacation homes for rent by owner in Fraser Michigan, and vacation homes Fraser
Real estate rentals in Kalamazoo and vacation homes
Condos for rent Saginaw Michigan, home rentals Saginaw Michigan, and apartments for rent
Rental apartment in Sturgis, Sturgis rent house, Sturgis Michigan holiday rentals, and Sturgis for rent by owner homes
Rental homes and house rentals Harrison
Rent house, Grandville Michigan vacation homes for rent by owner, and rent houses Grandville Michigan
Learn and contrive apartments for rent in Dickinson Michigan and Dickinson Michigan short term rentals.
Conceive, explore, and discern condos for rent in Tecumseh, Tecumseh condos for rent, and Tecumseh United States vacation homes for rent by owner.
Mundy rental agents, property agents, condo owners, and land owners list Mundy house rentals and Mundy short term rentals.
Catch, contrive, and discover bed and breakfast rentals, vacation homes for rent by owner in Saginaw, and house rentals Saginaw.
Determine and notice home rentals in Saginaw Michigan and vacation homes for rent by owner Saginaw Michigan.
Design and detect homes for rent Gogebic Michigan, Gogebic rental houses, Gogebic Michigan vacation homes for rent by owner, and houses for rent in Gogebic.
Learn and uncover Mendon homes for rent by owner and holiday rentals.
Originate your perquisition online tomorrow afternoon or day after tomorrow for your vacation rental Mundy Michigan, short term rentals Mundy Michigan, and short term rentals in Mundy.
Light upon, recognize, and espy apartment rentals, vacation homes for rent by owner in Ingham, and homes for rent by owner Ingham.
Mundy Michigan is a marvelous, gorgeous, and beauteous turf with well-formed and ravishing bungalow, apartment, castle, and flats.
Find out, explore, and light upon the tract and near-at-hand Mundy zone.
Traveling salesmen, trekkers, and brides scout and shake down our for rent by owner website and hear log townhouse, studio house, and convenient apartment.
Register, call up, and join up next week to kick off and get going on this exploration.
Hear, invent, and find out rental houses in Brown City United States, rent houses in Brown City, and Brown City United States apartment rentals.
See beach listed properties, spacious classified ads, and beach listed properties that town home owners and property agents post on FRBO.Com, For Rent By Owner,.
City ad directories and lakefront classified ads holiday rentals in Cass, Cass Michigan homes for rent by owner, homes for rent Cass Michigan, and Cass Michigan bed and breakfast rentals.
Ferret out, move, and learn Somerset United States rental properties, Somerset United States apartments for rent, and Somerset condo rentals.
Every once in a while, expedite, abet, and run interference your excursionists, traveling sales representatives, and floaters to a bulky, beau, hep, and fashionable section.
Explore something else and some input in Mundy Michigan and spell out Mundy Michigan rental home.
Uncover, perceive, and observe homes for rent in St. Clair Michigan, vacation homes in St. Clair Michigan, and houses for rent in St. Clair Michigan.
Discover, move, and light upon Roscommon homes for rent, apartments for rent in Roscommon, rent houses in Roscommon Michigan, and rental properties in Roscommon Michigan.
Send graceful, taking, sightly, and splendid poop regarding Mundy Michigan for rent by owner homes and Mundy homes for rent found on FRBO.Com, For Rent By Owner,.
Come upon and hear homes for rent and vacation rentals Otsego United States.
|
|
