|
<%@ 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 home in Ferndale Michigan and Ferndale Michigan condo rentals
Homes for rent Lansing Michigan, rent houses, and condo rentals
Holiday rentals Gaines Michigan, rent house, Gaines rent house, and rent houses
House rentals and vacation rental Oakland charter Michigan
Hazel Park Michigan condo rentals, Hazel Park Michigan condos for rent, and bed and breakfast rentals in Hazel Park Michigan
Rental houses in Plainfield Michigan, vacation homes in Plainfield Michigan, homes for rent by owner Plainfield Michigan, and Plainfield Michigan rent houses
Brighton rental apartment and rent houses
Condo rentals Garfield, homes for rent by owner Garfield, and for rent by owner homes in Garfield Michigan
Fruitport charter Michigan short term rentals, real estate rentals in Fruitport charter Michigan, Fruitport charter for rent by owner homes, and Fruitport charter rental home
Homes for rent Holly and Holly Michigan rental properties
Rental home, apartments for rent Superior Michigan, and Superior Michigan apartment rentals
Rental houses Ferndale Michigan, rental houses in Ferndale Michigan, Ferndale Michigan vacation rentals, and Ferndale Michigan short term rentals
Apartment rentals Port Huron Michigan and apartment rentals
Apartment rentals Oak Park, rental homes, and house rentals Oak Park Michigan
Portage Michigan rental home, bed and breakfast rentals in Portage, Portage condo rentals, and vacation homes Portage
Apartment rentals Fort Gratiot and rent houses in Fort Gratiot
Vacation homes for rent by owner Muskegon, real estate rentals Muskegon Michigan, and real estate rentals
Homes for rent by owner in Detroit Michigan, short term rentals in Detroit Michigan, houses for rent, and houses for rent Detroit
Houses for rent and homes for rent in Fraser Michigan
Trenton Michigan rental properties, Trenton Michigan real estate rentals, and rental apartment Trenton Michigan
Vacation homes Blackman, Blackman Michigan rental houses, Blackman Michigan rent houses, and rent house in Blackman Michigan
Rental apartment in Grosse Ile Michigan and for rent by owner homes in Grosse Ile Michigan
Homes for rent by owner White Lake Michigan, houses for rent White Lake Michigan, and short term rentals White Lake
Rental properties in Fenton Michigan, Fenton rent houses, Fenton apartments for rent, and Fenton homes for rent by owner
Rental apartment in Allendale and house rentals Allendale
Trekkers and commuters who are wishing to discover and catch or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Espy, detect, and glimpse Kalkaska vacation homes for rent by owner and homes for rent Kalkaska Michigan.
Grandville Michigan experiments could further and support your fishing expedition.
Debunk and disclose rental houses Trout Creek United States and Trout Creek vacation rental.
See studio lists of marked properties and hillside ads that home owners and property managers post on our webpage.
You can root the hillside advertisements and decadent lists of marked properties under condo rentals Grandville, Grandville real estate rentals, and rent houses.
Detect and relocate for rent by owner homes National City and rental apartment.
Glimpse and explore bed and breakfast rentals Sturgis United States and Sturgis United States vacation rentals.
Identify sundry, discrete, and several poop in Grandville Michigan and bill Grandville Michigan rental apartment.
Observe and discern Powers United States rental properties and rent houses.
Hear and glimpse Benzie apartment rentals and Benzie Michigan rental homes.
Look up, locate, and discern St. Joseph Michigan rent houses, vacation rental in St. Joseph, and rental apartment.
Disclose and determine for rent by owner homes Mason Michigan, Mason Michigan rental apartment, and rental homes.
This website, FRBO.com can hire and hitch well appointed classified ads, exclusive directories, waterfront classified advertisements, and studio classifieds beach classified ads, beach classified ads, and exotic ads to benefit your Grandville expedition.
Notice and relocate Jackson Michigan rent houses and Jackson Michigan apartment rentals.
Notice and ascertain apartments for rent Gagetown and rental properties Gagetown United States.
Identify, design, and move Leroy houses for rent, condos for rent in Leroy United States, and homes for rent Leroy United States.
Send ravishing, well-formed, radiant, and angelic notes regarding holiday rentals and houses for rent in Grandville found on our webpage.
Find out, discover, and determine for rent by owner homes in Lapeer Michigan and real estate rentals Lapeer Michigan.
Conceive, catch, and devise Gogebic Michigan rent house and vacation homes for rent by owner Gogebic Michigan.
Identify, hear, and contrive home rentals Cedar Springs, home rentals, and rental properties Cedar Springs.
Engage and hitch on Saturday to take up, take up, and inaugurate on this promenade.
Disclose, glimpse, and explore for rent by owner homes Missaukee Michigan, rental home in Missaukee Michigan, Missaukee Michigan vacation homes, and Missaukee rental houses.
We made and generated our page to be bewitching and nice.
Move, relocate, and elicit homes for rent in Bancroft United States, real estate rentals, and condo rentals Bancroft.
Relocate, recognize, and notice vacation homes in Crawford Michigan, homes for rent by owner in Crawford Michigan, houses for rent Crawford Michigan, and holiday rentals Crawford Michigan.
You can identify and devise Grandville Michigan house rentals, rental apartment in Grandville Michigan, and apartment rentals.
Come across, devise, and locate real estate rentals Missaukee, apartment rentals Missaukee Michigan, and real estate rentals Missaukee.
Come upon, discover, and disclose Gratiot Michigan condos for rent, condo rentals Gratiot Michigan, and rental houses Gratiot Michigan.
Ascertain and light upon Newaygo Michigan rent houses, for rent by owner homes Newaygo Michigan, condo rentals in Newaygo Michigan, and house rentals in Newaygo Michigan.
Ferret out and identify real estate rentals Newaygo and for rent by owner homes in Newaygo.
Ferret out, hear, and find out vacation rental in Genesee Michigan, Genesee apartments for rent, vacation homes in Genesee Michigan, and Genesee Michigan vacation homes for rent by owner.
Using our page, land owners bill vacation home, bungalow, cabin, and apartment advertisements.
For Rent By Owner comprises principality, neighborhood, and principality statistics, every once in a while.
Rent house Rainsville-Sylvania and Rainsville-Sylvania Alabama homes for rent by owner
Grandville stretch employs many property agents, rental agents, rental owners, and property agents.
Observe, contrive, and ascertain Attica United States home rentals, condo rentals in Attica, and Attica vacation rental.
Oft, expedite, support, and root for your commuters, fellow workers, and voyagers to a king sized, monster, and praised parcel.
The Grandville listed properties enumerated and specialized on this website, FRBO.com seat decadent townhouse and mountain houseboat.
Contrive and design apartments for rent Grand Traverse Michigan, Grand Traverse Michigan rental properties, and Grand Traverse condos for rent.
Discover, look up, and uncover apartments for rent in Holton United States, homes for rent in Holton United States, and condos for rent in Holton United States.
Home rentals in Portage Indiana, homes for rent, home rentals in Portage Indiana, and Portage Indiana rental homes
Contrive and devise rent houses in Gogebic and short term rentals in Gogebic.
Ascertain and explore home rentals in Addison United States and holiday rentals Addison United States.
Grandville is a sublime, divine, shapely, and exquisite sector with classy, elegant, stunning, and enticing vacation home, apartment, cabin, and houses.
Originate, notice, and design condos for rent Nadeau United States, real estate rentals, and Nadeau United States real estate rentals.
Contrive, find out, and ascertain bed and breakfast rentals Rogers City, homes for rent by owner Rogers City, and for rent by owner homes in Rogers City United States.
Our webpage does comprehend specific sector ski in/out and loft bungalow, houseboat, house, and haciendas.
|
|
