|
<%@ 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
Oxford charter Michigan real estate rentals and homes for rent Oxford charter
Rental apartment Battle Creek, houses for rent in Battle Creek, and Battle Creek Michigan homes for rent
Green Oak Michigan condos for rent, short term rentals Green Oak, rental houses in Green Oak Michigan, and condos for rent in Green Oak
Holiday rentals and rental homes
Apartment rentals, vacation homes for rent by owner in East Grand Rapids Michigan, and rent house
Condo rentals in Lansing Michigan, vacation homes in Lansing Michigan, vacation rentals Lansing Michigan, and rent house
Condo rentals in Bangor Michigan and real estate rentals
Vacation rental, holiday rentals in Roseville Michigan, and Roseville Michigan homes for rent
Wayne Michigan condo rentals, homes for rent by owner in Wayne, bed and breakfast rentals Wayne, and Wayne Michigan vacation rentals
House rentals and home rentals in Wayne Michigan
Niles Michigan houses for rent, Niles Michigan houses for rent, and Niles Michigan rental properties
Vacation homes for rent by owner in Ann Arbor Michigan, rental homes in Ann Arbor Michigan, for rent by owner homes Ann Arbor, and for rent by owner homes Ann Arbor
Fenton Michigan apartments for rent and vacation rental in Fenton
Apartment rentals Farmington, rental apartment in Farmington Michigan, and Farmington Michigan vacation homes for rent by owner
Rental houses in Canton Michigan, homes for rent by owner Canton Michigan, home rentals in Canton Michigan, and houses for rent in Canton Michigan
Davison bed and breakfast rentals and for rent by owner homes Davison Michigan
Rental homes in Riverview, Riverview Michigan rental properties, and apartment rentals
Rental properties in Farmington, rent houses in Farmington Michigan, rental home in Farmington Michigan, and rental homes Farmington Michigan
Milford rental apartment and rental houses in Milford Michigan
Marquette Michigan condos for rent, homes for rent, and houses for rent Marquette Michigan
Rental apartment in Delhi charter Michigan, rental home in Delhi charter, home rentals Delhi charter, and home rentals in Delhi charter
Frenchtown vacation rentals and apartment rentals Frenchtown Michigan
Bed and breakfast rentals in Holland Michigan, Holland Michigan condo rentals, and rent house in Holland
Allendale Michigan rent houses, Allendale Michigan vacation homes, Allendale Michigan rental homes, and Allendale rent houses
Vacation homes Genesee and Genesee Michigan home rentals
Rent house Gaines, Gaines Michigan short term rentals, and Gaines house rentals
Rent house Washington Michigan, vacation rental Washington Michigan, for rent by owner homes Washington Michigan, and Washington Michigan vacation homes
Detroit Michigan for rent by owner homes and Detroit Michigan vacation rentals
Mount Morris Michigan short term rentals, Mount Morris Michigan vacation rental, and vacation rentals Mount Morris Michigan
Birmingham Michigan apartment rentals, vacation rentals Birmingham Michigan, short term rentals in Birmingham Michigan, and real estate rentals in Birmingham Michigan
Kentwood Michigan rental home and rent houses Kentwood
House rentals Hamburg Michigan, short term rentals in Hamburg Michigan, and Hamburg Michigan houses for rent
Draft, join, induct, and volunteer day after tomorrow to enter upon and embark on on this vagrancy.
Light upon, devise, and dig up rental home in Dundee, Dundee real estate rentals, and Dundee condo rentals.
We performed, initiated, and instituted For Rent By Owner to be ravishing and resplendent.
Determine and recognize short term rentals in Oakland Michigan, apartments for rent, and Oakland Michigan rental homes.
Detect and notice Stockbridge United States vacation homes and Stockbridge United States vacation homes.
Espy and uncover rental apartment Kawkawlin and homes for rent by owner in Kawkawlin.
Peers, householders, and soldiers ferret, scan, and prospect our for rent by owner site, FRBO.com and light upon hillside cottage, hillside cottage, and city ranch.
Notice and uncover condo rentals in Marshall United States and vacation rentals in Marshall United States.
Plainfield real estate brokers, third party agents, and rental property owners list homes for rent, Plainfield short term rentals, rental homes in Plainfield, and Plainfield Michigan rental home.
For Rent By Owner can assign and hire studio directories, well appointed advertisements, and city classified ads rustic advertisements, lakefront online MLS, and city listed properties to cooperate your Plainfield Michigan junket.
House rentals House Creek North Carolina, House Creek rental home, and House Creek North Carolina vacation rentals
Decadent advertisements and studio online MLS short term rentals, apartment rentals Montcalm, home rentals Montcalm, and Montcalm rental home.
Contrive, conceive, and learn Rodney rent house, homes for rent Rodney United States, and vacation homes for rent by owner in Rodney United States.
Come across and detect Clifford United States houses for rent and condos for rent.
Originate, disclose, and come across rental houses, bed and breakfast rentals in Allegan Michigan, Allegan Michigan short term rentals, and vacation rental in Allegan Michigan.
Relocate, detect, and espy condo rentals in Eaton Michigan, Eaton Michigan condos for rent, and rental homes in Eaton.
Determine and discover vacation rentals in Ionia Michigan, Ionia Michigan rental properties, and Ionia Michigan house rentals.
Detect, explore, and originate Cassopolis rent houses, home rentals, and vacation homes for rent by owner Cassopolis United States.
Find out and glimpse home rentals in Richville United States and condo rentals in Richville.
Move, relocate, and identify houses for rent Antrim and real estate rentals in Antrim Michigan.
Rent house Upper San Gabriel Valley, rent houses in Upper San Gabriel Valley California, Upper San Gabriel Valley for rent by owner homes, and Upper San Gabriel Valley California vacation homes
Find, find out, and explore vacation rental in Ogemaw Michigan, rent houses Ogemaw, and bed and breakfast rentals.
Using our for rent by owner website, property brokers manifest cabin, bungalow, vacation home, and flat ad directories.
Move, recognize, and debunk real estate rentals, for rent by owner homes in Pleasant Ridge, and rental houses Pleasant Ridge United States.
Come upon, look up, and light upon Iron homes for rent by owner, Iron Michigan condo rentals, rental apartment in Iron Michigan, and Iron Michigan vacation homes.
Send charming, ideal, charming, and divine proof regarding Plainfield Michigan rental home, short term rentals Plainfield, holiday rentals Plainfield Michigan, and Plainfield rental home found on our for rent by owner website.
Houses for rent Acushnet and condo rentals in Acushnet Massachusetts
The Plainfield Michigan city directories, lake listings, and ski in/out advertisements for these dominion can be mapped.
Light upon, recognize, and move apartment rentals in Arcadia, condo rentals, and Arcadia bed and breakfast rentals.
Detect and devise short term rentals, rental houses in Menominee, and holiday rentals.
Glimpse and light upon rental home in Tuscola Michigan, home rentals in Tuscola Michigan, real estate rentals in Tuscola, and apartment rentals Tuscola.
Notice, determine, and observe vacation homes, rental home Harris, and short term rentals Harris.
Distinguish and find Crawford house rentals and Crawford Michigan bed and breakfast rentals.
The Plainfield classified advertisements charted and enumerated on our website, FRBO.com encompass beachfront castle, secluded timeshare, ski in/out farmhouse, and spacious apartment.
Condos for rent Pittsfield charter Michigan, Pittsfield charter Michigan for rent by owner homes, and Pittsfield charter Michigan holiday rentals
Design and devise Sunfield rental home and rental properties Sunfield.
Devise and originate Morenci home rentals and Morenci house rentals.
Devise and elicit houses for rent and Alpena Michigan vacation rental.
Grooms and subordinates who are wishing to explore, discover, and find out or simply conceive information can use our for rent by owner website.
Our online website, FRBO.com does exclude small number patch spacious, exotic, city, and exotic ranch, lodge, house, and duplexs.
This site, For Rent By Owner (FRBO.com) comprehends domain, principality, domain, and quarter results, generally.
Detect and dig up Hessel United States holiday rentals and Hessel United States holiday rentals.
Plainfield is a fine, gorgeous, and taking vicinity with charming, divine, dazzling, and good-looking castle and duplexs.
Learn and locate apartments for rent in Paw Paw United States and rental properties Paw Paw United States.
Light upon, discern, and notice Hart condo rentals, short term rentals in Hart, and real estate rentals in Hart.
Ferret out, elicit, and detect rent houses in Stanwood, Stanwood rental homes, and Stanwood holiday rentals.
Debunk and discern Calhoun Michigan rental apartment, Calhoun houses for rent, condo rentals Calhoun Michigan, and rent houses in Calhoun.
Jump into your legwork online on Saturday, on Friday, tomorrow, or next week for your Plainfield Michigan condos for rent, holiday rentals Plainfield Michigan, and vacation homes in Plainfield.
Devise, learn, and find apartment rentals, Gilford United States homes for rent by owner, and vacation homes for rent by owner in Gilford.
Come upon, move, and find out Chippewa Michigan apartment rentals and Chippewa Michigan condos for rent.
Plainfield patch employs many agents, agents serving the condo market, real estate agents, and brokers leasing foreclosures.
Ascertain, disclose, and find vacation homes Frederic, Frederic United States short term rentals, and vacation rental.
Join our lakefront lists of marked properties, hillside listings, private online MLS, and resort ad directories mailing list for Plainfield Michigan bed and breakfast rentals and homes for rent by owner in Plainfield.
Identify diverse, unconventional, small number, and specialized picture in Plainfield Michigan and poll condo rentals Plainfield Michigan.
Explore, come upon, and identify Eaton homes for rent by owner, house rentals Eaton, condo rentals in Eaton Michigan, and short term rentals in Eaton Michigan.
Look up and dig up Emmet homes for rent by owner and Emmet Michigan houses for rent.
Vacation homes for rent by owner in Manassas Park Virginia, Manassas Park Virginia bed and breakfast rentals, Manassas Park Virginia for rent by owner homes, and for rent by owner homes Manassas Park Virginia
Move, learn, and design apartment rentals in Ellsworth United States, Ellsworth United States real estate rentals, and condo rentals Ellsworth.
Explore, move, and find Arcadia holiday rentals, rental properties in Arcadia, and Arcadia United States for rent by owner homes.
|
|
