|
<%@ 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
Rent house Holland and Holland Michigan condos for rent
Rental homes, holiday rentals in Grand Haven Michigan, and bed and breakfast rentals
Vacation homes for rent by owner Mount Morris, Mount Morris Michigan for rent by owner homes, home rentals in Mount Morris Michigan, and rental homes in Mount Morris Michigan
Condo rentals Ferndale and rental properties in Ferndale Michigan
Rent house in Fenton Michigan, houses for rent in Fenton Michigan, and vacation homes in Fenton
Hamtramck Michigan vacation rentals, holiday rentals in Hamtramck Michigan, rental houses in Hamtramck Michigan, and rental home Hamtramck
Park Michigan rental apartment and real estate rentals Park Michigan
Rental properties in Bloomfield Michigan, bed and breakfast rentals Bloomfield, and condo rentals Bloomfield
Rental houses in Lincoln Park Michigan, vacation homes in Lincoln Park Michigan, Lincoln Park Michigan vacation rental, and houses for rent Lincoln Park
Brownstown rent houses and rental homes in Brownstown Michigan
Vacation rentals Harper Woods Michigan, home rentals, and apartments for rent in Harper Woods Michigan
Homes for rent by owner in Lyon Michigan, Lyon Michigan rent houses, vacation homes, and rental apartment
Delta charter Michigan rental home and Delta charter Michigan rent house
West Bloomfield Michigan home rentals, vacation rental in West Bloomfield Michigan, and vacation homes for rent by owner in West Bloomfield Michigan
Houses for rent in Southfield Michigan, apartments for rent in Southfield Michigan, Southfield Michigan rent house, and rental homes in Southfield
Apartment rentals and Ann Arbor rental homes
Houses for rent, rental apartment in Hamburg Michigan, and Hamburg Michigan holiday rentals
Monroe Michigan condo rentals, rental home in Monroe Michigan, Monroe Michigan condos for rent, and holiday rentals in Monroe
Vacation rentals in Canton Michigan and Canton Michigan short term rentals
For rent by owner homes Garfield, Garfield Michigan vacation homes for rent by owner, and home rentals in Garfield Michigan
Rental apartment, Blackman Michigan bed and breakfast rentals, rent house in Blackman Michigan, and rental properties in Blackman Michigan
Rental homes in Grand Rapids charter and Grand Rapids charter home rentals
Ferret out and look up apartments for rent in Seneca United States and rental homes.
Detect, discern, and perceive for rent by owner homes in Macomb Michigan, Macomb Michigan home rentals, home rentals Macomb Michigan, and real estate rentals in Macomb.
Dig up, originate, and uncover Lenawee vacation rentals, houses for rent in Lenawee, Lenawee Michigan homes for rent, and Lenawee Michigan houses for rent.
Identify something else and especial poop in Saginaw Michigan and run down for rent by owner homes Saginaw.
Contrive and ferret out rent houses Franklin and homes for rent in Franklin United States.
This website, FRBO.com encompasss area and precinct abstracts, every now and then.
Espy, learn, and perceive vacation rentals in Okemos United States, holiday rentals in Okemos United States, and home rentals Okemos.
Invent, relocate, and catch Allegan Michigan vacation homes and rental home in Allegan Michigan.
Ferret out and look up Otsego condos for rent, homes for rent in Otsego, apartments for rent, and rental properties in Otsego.
Saginaw condo owners, agents serving the condo market, land owners, and land owners list Saginaw Michigan holiday rentals, apartment rentals Saginaw, and holiday rentals in Saginaw Michigan.
Saginaw knowledge could work for and do for your hunt.
Espy and determine homes for rent by owner in Iosco, Iosco Michigan rental home, and apartment rentals in Iosco.
Identify, elicit, and notice apartment rentals Berrien Michigan and houses for rent in Berrien.
Secure, inscribe, enter into, and levy tonight to tear into, begin, get going, and tear into on this vagabondage.
Detect, conceive, and dig up vacation homes for rent by owner Houghton and rental apartment in Houghton.
This webpage does encompass some block hidden, penthouse, decadent, and beach castle, duplex, and farmhouses.
Saginaw neighborhood employs many property managers, rental owners, home owners, and landlords.
Venturers, dwellers, and lodgers root, grub, and quest this extensive website, FRBO.com and debunk beach house and secluded hacienda.
See well appointed lists of marked properties, ski in/out classifieds, lakefront listed properties, and penthouse classifieds that real estate brokers and home owners post on our site, FRBO.com.
We generated, fabricated, and dreamed up our page to be exquisite, classy, marvelous, and charming.
The Saginaw Michigan secluded listed properties, resort indexes, and exotic ads for these neighborhood can be mapped.
Espy and ferret out rental home Clinton and Clinton Michigan home rentals.
Distinguish and detect condo rentals in Iron, Iron Michigan rental properties, and real estate rentals.
Perceive, hear, and recognize rent houses in Lacota United States, rental properties in Lacota United States, and for rent by owner homes Lacota United States.
The Saginaw Michigan classifieds ticked off and catalogued on this site, For Rent By Owner (FRBO.com) except log apartment, hillside chalet, secluded chalet, and beachfront villa.
Uncover, locate, and elicit Eben Junction United States homes for rent, condo rentals, and vacation rentals Eben Junction.
Schoolmates and buddies who are going through Saginaw Michigan house rentals and are trying to hear Saginaw Michigan rent house and vacation rentals in Saginaw can explore our for rent by owner site, FRBO.com and our oceanfront ads, oceanfront classified advertisements, well appointed ads, and suburban listed properties.
Light upon, glimpse, and detect Genesee Michigan holiday rentals, rent houses in Genesee Michigan, Genesee Michigan homes for rent by owner, and Genesee apartment rentals.
Locate and debunk apartments for rent in Swartz Creek and short term rentals Swartz Creek United States.
|
|
