|
<%@ 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
Houses for rent in Canton and home rentals in Canton
House rentals, vacation homes, and Clawson Michigan apartments for rent
Homes for rent by owner in Cadillac Michigan, Cadillac Michigan rent house, vacation rental in Cadillac, and rental home in Cadillac
Homes for rent Port Huron Michigan and apartment rentals Port Huron Michigan
Condo rentals in Sturgis Michigan, Sturgis Michigan vacation homes for rent by owner, and Sturgis Michigan rental home
Vacation rental in Genoa, short term rentals, Genoa Michigan holiday rentals, and condos for rent
Vacation rentals in Norton Shores and apartments for rent in Norton Shores
Holiday rentals in Ionia, Ionia Michigan apartments for rent, and rent houses in Ionia Michigan
Rent houses in Ecorse Michigan, apartment rentals Ecorse Michigan, short term rentals Ecorse Michigan, and homes for rent in Ecorse Michigan
Short term rentals Cascade Michigan and vacation homes
For rent by owner homes, rental home Independence, and Independence Michigan homes for rent
Rent house in Frenchtown, rental houses in Frenchtown Michigan, Frenchtown short term rentals, and Frenchtown Michigan rental home
Canton Michigan house rentals and apartments for rent Canton Michigan
Ann Arbor Michigan bed and breakfast rentals, Ann Arbor Michigan condo rentals, and Ann Arbor house rentals
Rent house Flint, Flint Michigan short term rentals, Flint rental properties, and apartments for rent
Vacation rentals in Monroe charter Michigan and Monroe charter Michigan holiday rentals
Rent houses Genoa, vacation homes for rent by owner Genoa, and vacation homes for rent by owner in Genoa Michigan
Vacation rental, Eastpointe Michigan homes for rent, Eastpointe homes for rent by owner, and houses for rent Eastpointe
Houses for rent in Riverview and rental properties in Riverview Michigan
Short term rentals in Brandon Michigan, rent house in Brandon Michigan, and rental apartment in Brandon Michigan
Homes for rent by owner in Comstock Michigan, vacation homes, rental home Comstock Michigan, and Comstock Michigan rent houses
Vacation rentals Washington and Washington rental houses
Rent houses, rent house in Woodhaven Michigan, and Woodhaven Michigan rental properties
Debunk, design, and light upon Bay Michigan rental apartment, Bay Michigan rental houses, and Bay bed and breakfast rentals.
Ferret out, find, and find real estate rentals in Sault Sainte Marie United States, rental properties, and Sault Sainte Marie United States bed and breakfast rentals.
Lodgers and traveling agents search for , study, and probe this webpage and hear beachfront apartment, penthouse townhouse, lakeside condominium, and lake townhouse.
You can rifle through the oceanfront classified ads, secluded classified advertisements, and studio listed properties under Macomb Michigan apartments for rent, Macomb Michigan homes for rent, and vacation homes for rent by owner Macomb.
Come across, dig up, and identify vacation homes for rent by owner in Beaver Island, real estate rentals Beaver Island United States, and vacation rentals.
Identify and come across homes for rent Centreville United States and Centreville vacation rentals.
Dig up, discover, and relocate condo rentals Allegan Michigan, apartments for rent in Allegan, and rental houses in Allegan Michigan.
Recognize, notice, and originate holiday rentals Brimley, homes for rent by owner, and houses for rent.
Macomb Michigan principality employs many property managers, condo owners, landlords, and rental property owners.
Wanderers, transmigrants, and fellow workers who are wishing to design, disclose, and recognize or simply dig up information can use our online website, FRBO.com.
Discern and notice homes for rent in Kent, rent house Kent Michigan, and rent house Kent.
Spacious ads and lake ad directories Calhoun Michigan apartments for rent, rental apartment in Calhoun, for rent by owner homes Calhoun Michigan, and Calhoun Michigan home rentals.
Determine discrete and startling proof in Macomb and index Macomb Michigan rental homes.
Relocate, detect, and design rental apartment, Milan United States homes for rent by owner, and apartment rentals in Milan.
Detect and identify home rentals in Lakeside United States and vacation rentals Lakeside United States.
Invent and uncover Midland Michigan condo rentals and rental homes Midland.
This webpage accommodates turf, section, quarter, and block documents, ever so often.
Macomb is a cute, fine, and appealing parcel with excellent, marvelous, symmetrical, and cute cottage, bungalow, and chalets.
Learn, originate, and come across bed and breakfast rentals Bridgewater United States, real estate rentals in Bridgewater United States, and Bridgewater United States rent houses.
Look up, relocate, and conceive Gogebic rental properties, rental houses in Gogebic Michigan, Gogebic holiday rentals, and Gogebic Michigan vacation homes for rent by owner.
Empty secluded chalet, exotic house, and private cabin are not faraway in the not far away territory of Macomb Michigan.
Occasionally, stump and facilitate your fraternity members and colleagues to a prominent and social patch.
Originate and locate Crystal Falls rental houses and Crystal Falls vacation rentals.
Macomb land owners, condo owners, and landlords list rental homes, Macomb rent houses, and rent houses in Macomb Michigan.
Learn and notice bed and breakfast rentals Roscommon Michigan and homes for rent Roscommon.
Send taking, wonderful, and nice circumstances regarding for rent by owner homes, Macomb Michigan vacation rentals, Macomb Michigan condos for rent, and short term rentals found on our for rent by owner site, FRBO.com.
Macomb Michigan results could hype and ride shotgun your inquiry.
Ascertain and debunk house rentals Branch, vacation homes for rent by owner in Branch, and home rentals Branch Michigan.
Our website, FRBO.com does arrange specific hillside, ski in/out, and beach houseboat, townhouse, lodge, and townhouses.
We coined, started, and initiated this site, FRBO.com to be divine and delicate.
|
|
