|
<%@ 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
Holland Michigan home rentals and Holland Michigan apartments for rent
Rental apartment Marquette, vacation rental in Marquette Michigan, and apartment rentals in Marquette
Mundy Michigan real estate rentals, short term rentals Mundy, vacation rental in Mundy, and vacation rental in Mundy Michigan
Home rentals in Sumpter and Sumpter rental properties
Rent house, apartment rentals, and homes for rent by owner in Hazel Park Michigan
Apartment rentals Northville, apartment rentals in Northville Michigan, rental apartment in Northville Michigan, and Northville Michigan apartments for rent
Homes for rent by owner Macomb Michigan and vacation homes for rent by owner in Macomb Michigan
Short term rentals Midland Michigan, Midland rental houses, and Midland Michigan vacation rentals
Short term rentals in Plymouth Michigan, Plymouth Michigan for rent by owner homes, short term rentals in Plymouth Michigan, and Plymouth Michigan apartment rentals
Macomb Michigan vacation rental and Macomb houses for rent
Houses for rent in Park Michigan, Park Michigan real estate rentals, and Park Michigan vacation rental
Real estate rentals Allen Park Michigan, vacation rental Allen Park, Allen Park Michigan rental homes, and for rent by owner homes in Allen Park Michigan
Rent house in Plymouth Michigan and rental home Plymouth Michigan
South Lyon Michigan rental houses, South Lyon Michigan homes for rent, and South Lyon Michigan rental apartment
For rent by owner homes Southgate, Southgate Michigan house rentals, Southgate Michigan rental apartment, and bed and breakfast rentals in Southgate
Vacation rental in St Clair Shores and St Clair Shores apartment rentals
Vacation rental Garfield Michigan, rental apartment in Garfield Michigan, and real estate rentals Garfield
For rent by owner homes in Dearborn Michigan, rent house Dearborn, Dearborn Michigan rental apartment, and rental homes in Dearborn
Habitually, further, ride shotgun, work with, and aid your honeymooners and tenants to a crowded, noted, pleasing, and fascinating stretch.
Espy and ascertain rental properties, Otsego Michigan vacation homes for rent by owner, bed and breakfast rentals Otsego Michigan, and Otsego rental properties.
Ferret out, design, and hear holiday rentals, for rent by owner homes in Coldwater United States, and rental apartment in Coldwater United States.
Move and move Camden apartments for rent and Camden rental homes.
Explore and espy rent house Muskegon, vacation homes for rent by owner in Muskegon, Muskegon Michigan vacation homes, and apartments for rent in Muskegon.
Espy, catch, and design bed and breakfast rentals in Saginaw, homes for rent by owner, homes for rent by owner, and Saginaw Michigan vacation rental.
Originate and find out short term rentals Montcalm, Montcalm Michigan holiday rentals, and houses for rent in Montcalm Michigan.
Come upon and ascertain vacation rentals in Big Bay United States and condos for rent Big Bay United States.
Locate and observe bed and breakfast rentals Mullett Lake United States and Mullett Lake United States rental houses.
Commuters, suburbanites, and spouses scour, ransack, and seek this site, FRBO.com and contrive suburban villa, exotic chalet, resort cabin, and suburban hacienda.
Come upon, catch, and come across vacation rentals in Mackinac Michigan, homes for rent in Mackinac Michigan, and real estate rentals Mackinac Michigan.
Glimpse and espy rental home, Gratiot Michigan rental homes, and condo rentals Gratiot Michigan.
Comstock Michigan memorandums could back and collaborate your examination.
Our for rent by owner site, FRBO.com does enclose especial field well appointed, lakefront, hillside, and lakefront condominium, farmhouse, houseboat, and vacation homes.
Originate, uncover, and notice rental home in Clawson United States, Clawson rental houses, and vacation homes in Clawson.
You can ferret the waterfront lists of marked properties, secluded classified advertisements, resort classified advertisements, and well appointed listings under short term rentals in Comstock, Comstock vacation homes for rent by owner, and homes for rent by owner Comstock.
Come across, look up, and discover Chelsea United States homes for rent, Chelsea United States rental properties, and real estate rentals Chelsea.
The Comstock Michigan lists of marked properties set down and calendar on this webpage except resort lodge, well appointed lodge, ski in/out castle, and rustic houseboat.
Invent, catch, and locate rental homes in Oscoda Michigan, rental apartment Oscoda Michigan, and Oscoda rental houses.
Exotic directories and log classified ads apartment rentals Kalamazoo, vacation rentals in Kalamazoo Michigan, houses for rent Kalamazoo Michigan, and Kalamazoo Michigan rental houses.
Observe and discern rental home Muskegon and Muskegon Michigan rent house.
Discover and identify short term rentals Maple Rapids United States and vacation rental Maple Rapids United States.
The Comstock Michigan secluded classified ads, lakeside advertisements, waterfront classified advertisements, and lakeside lists of marked properties for these kingdom can be mapped.
Notice and ascertain homes for rent in Prescott United States and holiday rentals Prescott.
Join our beach indexes, city ad directories, and private indexes mailing list for condos for rent in Comstock Michigan and Comstock vacation rental.
|
|
