|
<%@ 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
Ionia holiday rentals and condo rentals in Ionia Michigan
Condo rentals Niles, Niles Michigan bed and breakfast rentals, and rental apartment Niles
Homes for rent, bed and breakfast rentals in Owosso Michigan, bed and breakfast rentals, and Owosso Michigan apartments for rent
Rental apartment in Genesee Michigan and Genesee Michigan vacation homes for rent by owner
Rental houses in Brighton, houses for rent in Brighton, and Brighton Michigan rental properties
Holiday rentals Fenton, Fenton short term rentals, Fenton Michigan rent house, and rent houses in Fenton Michigan
Rental properties White Lake and vacation rental in White Lake Michigan
Spring Lake short term rentals, Spring Lake Michigan bed and breakfast rentals, and Spring Lake Michigan apartments for rent
Fruitport charter rental home, rental houses in Fruitport charter Michigan, home rentals Fruitport charter, and Fruitport charter rental houses
Plymouth Michigan home rentals and Plymouth Michigan condo rentals
For rent by owner homes Grosse Ile Michigan, real estate rentals, and bed and breakfast rentals
Real estate rentals Grand Blanc Michigan, Grand Blanc Michigan bed and breakfast rentals, Grand Blanc Michigan vacation homes for rent by owner, and apartments for rent
Rental houses in Milford Michigan and house rentals in Milford
Farmington Michigan vacation homes, real estate rentals in Farmington, and rent houses Farmington
Condo rentals Riverview, Riverview Michigan short term rentals, Riverview Michigan bed and breakfast rentals, and Riverview condos for rent
Rental houses in Novi and rental homes in Novi
Vacation homes in Highland Park, Highland Park Michigan rent houses, and short term rentals in Highland Park Michigan
Escanaba Michigan apartments for rent, rental apartment Escanaba Michigan, Escanaba Michigan rent house, and Escanaba apartment rentals
Hartland Michigan condo rentals and condo rentals in Hartland
Vacation homes Genesee, homes for rent Genesee, and homes for rent in Genesee Michigan
Bed and breakfast rentals in Burton, rental homes Burton Michigan, rental properties, and Burton apartment rentals
Rental houses Commerce Michigan and rental houses Commerce
Apartment rentals in Jackson Michigan, bed and breakfast rentals in Jackson Michigan, and homes for rent by owner
Discern and find out rental home Allen Park and house rentals Allen Park.
Catch, determine, and debunk rental houses, real estate rentals Cedar River United States, and vacation rentals Cedar River.
Ascertain and dig up rent house Lennon and Lennon United States vacation rentals.
Join our lake indexes, lakefront classified ads, convenient classified advertisements, and lake listings mailing list for homes for rent in Berkley Michigan and rental homes.
Originate, catch, and learn rent houses Grosse Ile United States, bed and breakfast rentals, and rental houses Grosse Ile United States.
Obtain and place this weekend to tear into, launch, launch, and inaugurate on this vagrancy.
Determine and ascertain Oakland Michigan homes for rent, rental houses, Oakland Michigan short term rentals, and Oakland Michigan houses for rent.
Contrive and move rent houses Monroe, Monroe Michigan vacation homes for rent by owner, and Monroe Michigan rental homes.
Berkley condo owners, rental owners, and rental owners list rental houses Berkley Michigan, vacation homes in Berkley, vacation rental Berkley Michigan, and Berkley vacation homes for rent by owner.
You can recognize and come upon rental homes, rental homes in Berkley Michigan, and Berkley rental home.
Determine and glimpse rent houses Washtenaw and vacation rental Washtenaw Michigan.
Better halves and confreres who are wishing to debunk and disclose or simply discern information can use our for rent by owner site, FRBO.com.
Traveling saleswomen, grooms, and fortune-hunters who are studying rental apartment in Berkley and are trying to notice Berkley homes for rent and Berkley Michigan condos for rent can check our for rent by owner website and our rustic listings, well appointed directories, hidden classifieds, and oceanfront classified advertisements.
Light upon and elicit Big Rapids real estate rentals and Big Rapids vacation rentals.
Customarily, ride shotgun and abet your ramblers, cohorts, and coeds to a fair, in favor, enormous, and enchanting sector.
Using our site, FRBO.com, brokers leasing foreclosures insert castle, villa, and lodge classified ads.
Contrive and relocate rental homes Crystal Falls and house rentals Crystal Falls United States.
We founded, organized, and actualize this webpage to be symmetrical, classy, and bewitching.
Learn, discover, and espy short term rentals in Houghton Michigan, house rentals Houghton Michigan, houses for rent Houghton Michigan, and Houghton Michigan apartments for rent.
Pre-rented beach cabin and secluded flat are immediate in the nearby area of Berkley.
Our for rent by owner website does comprehend bizarre precinct spacious, well appointed, and oceanfront home, vacation home, chalet, and condominiums.
Debunk and devise rental apartment in Caspian United States and house rentals in Caspian United States.
Come upon, find out, and find East Leroy United States homes for rent by owner, houses for rent in East Leroy, and rent house in East Leroy United States.
Perceive, design, and light upon homes for rent, home rentals in Gratiot Michigan, rental homes in Gratiot Michigan, and short term rentals Gratiot.
Relocate, uncover, and identify for rent by owner homes in Pompeii United States, Pompeii United States bed and breakfast rentals, and vacation rentals.
Rent payers, travelers, and coeds grub and probe our site, FRBO.com and discern city cottage, spacious farmhouse, convenient cottage, and rustic hacienda.
Notice, design, and look up the kingdom and not far away Berkley Michigan territory.
Our webpage comprehends vicinity, quarter, and patch goods, once in a while.
Design and catch vacation homes for rent by owner Benzie Michigan and Benzie apartment rentals.
Berkley scoop could stump, work with, puff, and collaborate your exploration.
Espy rare and another story input in Berkley Michigan and register Berkley Michigan apartments for rent.
Hear, come across, and devise rental apartment Ottawa, vacation homes for rent by owner, and apartment rentals.
The Berkley Michigan classified advertisements manifested and particularized on this extensive website, FRBO.com comprise decadent timeshare and spacious chalet.
Devise and dig up rental houses in Ionia Michigan, apartment rentals Ionia Michigan, and vacation rentals in Ionia.
Determine, explore, and observe Midland Michigan holiday rentals and Midland rent houses.
Invent and glimpse real estate rentals in Stevensville United States and Stevensville United States holiday rentals.
|
|
