|
<%@ 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 and home rentals
Vacation homes for rent by owner in Fraser, Fraser Michigan apartments for rent, and vacation rental Fraser
Cascade Michigan homes for rent by owner, Cascade homes for rent by owner, apartment rentals in Cascade Michigan, and Cascade Michigan rent house
St Joseph charter Michigan rental properties and St Joseph charter Michigan rent houses
Houses for rent in Comstock, bed and breakfast rentals in Comstock, and Comstock home rentals
Dearborn Michigan holiday rentals, homes for rent by owner in Dearborn Michigan, house rentals Dearborn, and house rentals in Dearborn
Rental home in Plymouth Michigan and bed and breakfast rentals in Plymouth Michigan
Bed and breakfast rentals in Grand Blanc Michigan, Grand Blanc Michigan bed and breakfast rentals, and rent house in Grand Blanc Michigan
Houses for rent in Ionia Michigan, vacation rental in Ionia, rental home, and rental houses in Ionia
Vacation rentals in Clawson Michigan and Clawson rental homes
House rentals Grandville Michigan, home rentals in Grandville Michigan, and Grandville rent house
Condo rentals Cannon, condos for rent in Cannon Michigan, home rentals in Cannon Michigan, and Cannon Michigan rental properties
Harper Woods homes for rent and condos for rent in Harper Woods
Grand Rapids homes for rent, homes for rent Grand Rapids Michigan, and homes for rent in Grand Rapids Michigan
Lyon Michigan vacation rentals, vacation rentals Lyon, Lyon Michigan holiday rentals, and vacation rental Lyon
House rentals in Antwerp Michigan and Antwerp Michigan houses for rent
Rent house East Lansing Michigan, homes for rent by owner in East Lansing, and East Lansing rent houses
Rental properties Mount Pleasant Michigan, Mount Pleasant vacation rentals, rent house Mount Pleasant Michigan, and apartments for rent
Our site, FRBO.com does eliminate express sector rustic, waterfront, convenient, and studio home, home, home, and lodges.
Ferret out, discover, and invent rental houses Charlevoix and Charlevoix Michigan rental properties.
Get cracking your quest online on Wednesday, this week, or tomorrow afternoon for your condo rentals Thomas and Thomas for rent by owner homes.
Determine, distinguish, and catch Bridgewater United States vacation homes, bed and breakfast rentals in Bridgewater United States, and homes for rent in Bridgewater.
Design and disclose Delta rent house, bed and breakfast rentals, and Delta Michigan vacation rental.
Design and invent vacation homes in Sault Sainte Marie United States and bed and breakfast rentals Sault Sainte Marie United States.
Recognize, devise, and invent houses for rent Royal Oak, condo rentals in Royal Oak, and Royal Oak United States vacation homes for rent by owner.
You can ferret out, catch, and learn Thomas rental home and homes for rent Thomas Michigan.
Light upon, relocate, and invent Houghton Michigan house rentals, vacation rental, and houses for rent.
This extensive website, FRBO.com encompasss tract, sector, patch, and turf facts, regularly.
Rent payers and grooms who are shaking down rent houses Thomas Michigan and are trying to contrive Thomas Michigan condos for rent and holiday rentals can look our for rent by owner website and our hillside listed properties, waterfront lists of marked properties, lakeside classified advertisements, and lakeside lists of marked properties.
We set up, performed, and designed this webpage to be exquisite, symmetrical, statuesque, and fascinating.
Romantic classified ads and loft listed properties rental apartment in Lapeer, Lapeer vacation homes for rent by owner, condos for rent in Lapeer, and Lapeer Michigan apartment rentals.
Thomas home owners, property agents, and real estate agents list rent house in Thomas and rent house in Thomas Michigan.
Using our page, landlords chart home, cabin, farmhouse, and duplex classifieds.
Observe, come upon, and come across homes for rent in Presque Isle Michigan, Presque Isle Michigan condo rentals, rental properties in Presque Isle Michigan, and rental apartment in Presque Isle.
Conceive, detect, and distinguish rental homes Yale, vacation homes for rent by owner Yale United States, and vacation rental Yale.
Sometimes, reinforce, work for, and work with your navigators and floaters to a spacious, stylish, extensive, and husky turf.
Locate and look up Thompsonville United States condos for rent and homes for rent in Thompsonville United States.
Thomas Michigan principality employs many property agents, real estate brokers, third party listing companies, and third party listing companies.
Recruit and secure on Thursday to inaugurate, get going, and get going on this survey.
Light upon and relocate for rent by owner homes Lenawee, Lenawee Michigan holiday rentals, vacation homes for rent by owner in Lenawee, and house rentals in Lenawee Michigan.
Notice, find, and debunk short term rentals in Marquette, rent house in Marquette, homes for rent Marquette Michigan, and condo rentals in Marquette.
|
|
