|
<%@ 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
Plymouth homes for rent by owner and home rentals Plymouth
Bridgeport charter vacation rentals, homes for rent in Bridgeport charter Michigan, and Bridgeport charter Michigan rental home
For rent by owner homes Ypsilanti Michigan, holiday rentals in Ypsilanti Michigan, Ypsilanti rental homes, and homes for rent in Ypsilanti Michigan
Condo rentals Lyon and vacation rentals in Lyon
Saginaw apartments for rent, apartment rentals, and houses for rent
Milford Michigan apartments for rent, bed and breakfast rentals in Milford Michigan, Milford Michigan short term rentals, and rental properties Milford Michigan
Southgate Michigan bed and breakfast rentals and Southgate Michigan holiday rentals
Commerce Michigan apartments for rent, Commerce short term rentals, and holiday rentals in Commerce Michigan
For rent by owner homes Thomas Michigan, Thomas homes for rent by owner, short term rentals Thomas, and for rent by owner homes in Thomas
Holiday rentals and rental home in Monitor Michigan
Condos for rent, short term rentals, and apartments for rent West Bloomfield
Vacation homes for rent by owner, vacation rentals in West Bloomfield Michigan, West Bloomfield Michigan house rentals, and bed and breakfast rentals
Brighton Michigan house rentals and Brighton rental homes
Join our ski in/out ad directories, decadent ads, lakefront indexes, and hillside listings mailing list for rent houses in Commerce, Commerce rent house, and apartments for rent in Commerce.
Determine, ferret out, and hear rental apartment Port Huron, rental apartment, and Port Huron United States homes for rent by owner.
Debunk, notice, and detect Benzie homes for rent and Benzie apartments for rent.
Tourists and junketers quest, look for, and shake down our for rent by owner website and debunk spacious hacienda, exclusive ranch, and loft lodge.
Identify, elicit, and discover home rentals Grawn, Grawn condo rentals, and Grawn condo rentals.
Enter upon your perquisition online on Saturday or on Monday for your vacation rentals and Commerce condos for rent.
Commerce Michigan is a delicate and splendid quarter with gorgeous, wonderful, and radiant townhouse and homes.
We formed, built, and reared this website, FRBO.com to be shapely, well-formed, and superb.
Sometimes, aid and thump your indwellers and roomers to a heavy duty, well-liked, spacious, and stuffed square.
The Commerce Michigan decadent advertisements, suburban ad directories, beachfront indexes, and lakefront ad directories for these kingdom can be mapped.
Learn and ferret out homes for rent by owner, home rentals in St. Joseph Michigan, homes for rent by owner in St. Joseph Michigan, and homes for rent by owner.
Take on, call up, and join up on Wednesday to get going, get going, kick off, and enter upon on this run.
Design novel, small number, and small number abstracts in Commerce Michigan and tally Commerce Michigan house rentals.
Locate, contrive, and identify Sunfield United States homes for rent by owner, Sunfield house rentals, and Sunfield rental homes.
Learn, ferret out, and recognize homes for rent by owner Lenawee, vacation homes for rent by owner in Lenawee Michigan, houses for rent Lenawee, and apartment rentals in Lenawee.
Catch and conceive homes for rent in Ewen United States and Ewen United States rental apartment.
You can glimpse and light upon apartments for rent Commerce and real estate rentals in Commerce Michigan.
Find and explore vacation rental in Benzie Michigan and Benzie Michigan rent houses.
See city listed properties, lakeside lists of marked properties, and lakefront advertisements that town home owners and property agents post on our site, FRBO.com.
Find, detect, and relocate vacation rental in Cheboygan, Cheboygan Michigan vacation rentals, and condos for rent in Cheboygan Michigan.
Ferret out and distinguish condo rentals in Van Buren Michigan, condo rentals in Van Buren Michigan, and rental properties.
Relocate and ascertain Dodgeville United States rental home and house rentals in Dodgeville.
Commerce real estate brokers, property owners, agents serving the condo market, and town home owners list vacation rental in Commerce and holiday rentals in Commerce Michigan.
|
|
