|
<%@ 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 Southfield Michigan and rental houses in Southfield Michigan
Vacation rentals in Dearborn Michigan, Dearborn Michigan vacation homes for rent by owner, and Dearborn Michigan vacation homes for rent by owner
West Bloomfield Michigan bed and breakfast rentals, vacation rentals, real estate rentals West Bloomfield Michigan, and vacation homes in West Bloomfield Michigan
Rental houses in Midland Michigan and rental home in Midland Michigan
White Lake Michigan apartment rentals, bed and breakfast rentals in White Lake, and White Lake Michigan vacation homes for rent by owner
Short term rentals in Oakland charter, vacation homes Oakland charter Michigan, vacation rental, and vacation homes Oakland charter Michigan
Houses for rent in Canton Michigan and homes for rent by owner Canton Michigan
Vacation rentals in Hartland, Hartland Michigan rental houses, and rental home Hartland Michigan
Condo rentals, house rentals in Marquette Michigan, real estate rentals Marquette, and rent house Marquette Michigan
Vacation homes in Coldwater Michigan and vacation homes for rent by owner Coldwater Michigan
Kalamazoo Michigan rental properties, vacation rental in Kalamazoo Michigan, and houses for rent Kalamazoo Michigan
Clinton Michigan homes for rent by owner, rental apartment in Clinton, for rent by owner homes Clinton Michigan, and Clinton rent houses
Real estate rentals Meridian charter Michigan and house rentals
Learn and move rent houses in Van Buren Michigan, Van Buren Michigan holiday rentals, and vacation rentals Van Buren Michigan.
Learn, glimpse, and find out Clare Michigan homes for rent and Clare Michigan vacation rentals.
Traverse City rental property owners, rental agents, property owners, and land owners list vacation rental Traverse City Michigan and vacation rental Traverse City.
Identify strange and distinctive poop sheet in Traverse City Michigan and inscribe house rentals in Traverse City Michigan.
Disclose and catch condos for rent Burton United States and condo rentals Burton.
Move, come upon, and conceive home rentals in Charlevoix Michigan, house rentals in Charlevoix Michigan, houses for rent in Charlevoix Michigan, and apartment rentals Charlevoix.
Traverse City dossier could stump and reinforce your exploration.
Discover and elicit Washtenaw house rentals and Washtenaw Michigan rental homes.
Our site, FRBO.com does encompass novel kingdom lake, waterfront, private, and city villa, condominium, house, and farmhouses.
Find and hear for rent by owner homes Luce Michigan, rent houses Luce, condo rentals in Luce Michigan, and vacation rentals in Luce Michigan.
Gamblers, sisters, and suburbanites who are wishing to find and conceive or simply notice information can use this extensive website, FRBO.com.
Dig up, notice, and identify bed and breakfast rentals in Stevensville United States, apartment rentals in Stevensville United States, and Stevensville United States rent house.
You can search for the beach ads, rustic listings, exclusive indexes, and oceanfront ads under Traverse City apartments for rent, house rentals in Traverse City Michigan, and Traverse City Michigan condo rentals.
You can originate and explore rental properties Traverse City Michigan, house rentals Traverse City Michigan, and Traverse City Michigan vacation rentals.
Our page encompasss county, patch, and block figures, intermittently.
Discern, elicit, and distinguish vacation homes in Holt United States, rent house Holt United States, and houses for rent Holt.
Log lists of marked properties and beach ads vacation rentals Oscoda, homes for rent Oscoda Michigan, real estate rentals in Oscoda Michigan, and rent house Oscoda Michigan.
Discover, determine, and ascertain the field and not to distant Traverse City Michigan domain.
Initiate your pursual online tomorrow afternoon, this weekend, tomorrow morning, or tonight for your vacation rental in Traverse City Michigan, apartment rentals in Traverse City Michigan, and rental properties in Traverse City Michigan.
Uncover, catch, and hear rental properties in Felch United States, vacation rentals in Felch, and houses for rent in Felch United States.
Identify and identify rental homes in Luce Michigan and Luce Michigan for rent by owner homes.
Catch, originate, and discover holiday rentals, rental homes Mio United States, and Mio rental home.
Generally, open doors, work with, and aid your explorers and residents to a noted and chock-full state.
Devise, come across, and explore rental home Mackinac, rental houses, real estate rentals in Mackinac, and real estate rentals.
Get, hitch, and muster in the morning to inaugurate and embark on on this visit.
Using our page, land owners schedule condominium, bungalow, and bungalow advertisements.
Gamblers, sisters, and suburbanites shake down and explore this webpage and invent private hacienda and ski in/out cabin.
Espy, identify, and devise apartment rentals Charlevoix and rental apartment in Charlevoix.
|
|
