|
<%@ 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
Bay City Michigan short term rentals and Bay City homes for rent by owner
Southfield rental apartment, Southfield Michigan houses for rent, and houses for rent Southfield Michigan
Bed and breakfast rentals, Lincoln charter vacation homes, rental houses, and Lincoln charter Michigan bed and breakfast rentals
Oxford charter Michigan rental apartment and Oxford charter Michigan house rentals
Short term rentals Fruitport charter, house rentals in Fruitport charter, and apartments for rent Fruitport charter Michigan
Trenton Michigan vacation homes for rent by owner, holiday rentals in Trenton Michigan, vacation rental in Trenton Michigan, and house rentals
Grand Haven for rent by owner homes and Grand Haven holiday rentals
Vacation homes for rent by owner, Lyon Michigan rental home, and Lyon rent houses
Holiday rentals in Emmett Michigan, apartments for rent in Emmett Michigan, Emmett rental home, and vacation rental in Emmett Michigan
Rental homes and Fort Gratiot Michigan houses for rent
Vacation homes, Bay City condos for rent, and Bay City Michigan real estate rentals
Texas Michigan vacation rentals, condos for rent, Texas Michigan condo rentals, and rental homes Texas
Rent houses Dearborn Heights Michigan and Dearborn Heights apartment rentals
Canton Michigan holiday rentals, rental properties, and Canton Michigan house rentals
Rent houses Monroe charter Michigan, Monroe charter apartment rentals, rental homes Monroe charter, and vacation homes in Monroe charter Michigan
Rent houses in Muskegon Heights Michigan and vacation rental Muskegon Heights
Short term rentals in Pontiac Michigan, Pontiac Michigan rent house, and apartment rentals in Pontiac Michigan
Rent houses in Springfield Michigan, Springfield Michigan houses for rent, houses for rent, and real estate rentals Springfield Michigan
Find, observe, and locate Otsego Michigan homes for rent by owner and Otsego Michigan house rentals.
You can search for the hidden classified advertisements, beachfront lists of marked properties, lake ad directories, and exclusive ad directories under for rent by owner homes and vacation rental in Ferndale.
Distinguish and move Antrim Michigan vacation homes for rent by owner, Antrim rental homes, and vacation rentals in Antrim Michigan.
Originate and originate home rentals and Bay Port for rent by owner homes.
Observe, disclose, and identify vacation rental in Gladwin Michigan and vacation homes Gladwin Michigan.
Originate and discern real estate rentals in Berrien Springs United States and vacation rentals in Berrien Springs United States.
Find, explore, and contrive Calhoun Michigan vacation homes for rent by owner, home rentals in Calhoun Michigan, and Calhoun Michigan condo rentals.
The Ferndale Michigan beach lists of marked properties, beach lists of marked properties, penthouse directories, and hidden listed properties for these can be mapped.
Detect and hear holiday rentals in Hancock United States and homes for rent by owner Hancock.
Ferret out, ferret out, and relocate Montcalm condo rentals, rent houses, condo rentals Montcalm Michigan, and Montcalm condos for rent.
Ferndale Michigan info could work for, open doors, and push your pursual.
Move, explore, and look up house rentals in Ottawa, homes for rent by owner in Ottawa Michigan, houses for rent Ottawa, and rental home.
Send dazzling, statuesque, and beauteous dossier regarding vacation homes Ferndale, home rentals in Ferndale, and apartments for rent Ferndale Michigan found on our for rent by owner site, FRBO.com.
Find out several and atypical dossier in Ferndale Michigan and chart rental properties Ferndale.
You can find, ferret out, and uncover rent houses and apartment rentals Ferndale.
We occasioned, dreamed up, and parented this webpage to be appealing, appealing, and appealing.
Ferndale is a exquisite and dazzling turf with exquisite and dazzling hacienda, cabin, and castles.
Elicit and ferret out Kingsley condos for rent and vacation rental Kingsley.
Hear, find, and catch bed and breakfast rentals in Somerset Center United States, Somerset Center United States short term rentals, and condo rentals in Somerset Center United States.
Learn, glimpse, and dig up Lenawee Michigan houses for rent, rental houses Lenawee Michigan, and Lenawee Michigan homes for rent.
Glimpse and catch rental apartment and short term rentals in Dowling.
Take up your research online this week or tomorrow evening for your rent houses in Ferndale Michigan and Ferndale apartments for rent.
Locate and come upon rental home in Alden United States and Alden United States bed and breakfast rentals.
Look up and find vacation rentals and home rentals in Perrinton United States.
Conceive, identify, and come across Branch United States house rentals, Branch United States rental houses, and Branch United States short term rentals.
Ferndale agents serving the condo market, property owners, and real estate investors list Ferndale Michigan houses for rent, Ferndale Michigan rental houses, Ferndale condo rentals, and vacation rental in Ferndale Michigan.
|
|
