|
<%@ 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 Royal Oak and Royal Oak Michigan vacation homes for rent by owner
Traverse City Michigan rental homes, Traverse City apartment rentals, and home rentals
Alpine house rentals, real estate rentals in Alpine Michigan, houses for rent Alpine Michigan, and real estate rentals in Alpine Michigan
Wyoming Michigan for rent by owner homes and real estate rentals in Wyoming Michigan
Rental properties in Trenton Michigan, condo rentals in Trenton Michigan, and apartment rentals Trenton Michigan
Wixom Michigan apartment rentals, Wixom short term rentals, Wixom real estate rentals, and bed and breakfast rentals Wixom
Rent house in Berkley Michigan and vacation rental in Berkley
Apartments for rent, rental home in Grand Haven Michigan, and rental apartment in Grand Haven Michigan
Houses for rent Bedford Michigan, rent house in Bedford Michigan, apartments for rent in Bedford, and short term rentals
Antwerp Michigan vacation rentals and for rent by owner homes in Antwerp Michigan
Holiday rentals in Ecorse, houses for rent Ecorse, and rent houses Ecorse Michigan
Apartment rentals in Wayne, vacation rental, apartment rentals, and rental home Wayne
Vacation homes and Leoni house rentals
Holland Michigan apartment rentals, Holland Michigan condo rentals, and Holland Michigan vacation rentals
Jackson Michigan real estate rentals, Jackson Michigan bed and breakfast rentals, rental properties Jackson, and vacation rentals Jackson Michigan
De Witt condo rentals and rental homes De Witt
Kalamazoo Michigan short term rentals, short term rentals, and rent house in Kalamazoo Michigan
Rental homes in Springfield Michigan, short term rentals Springfield Michigan, house rentals, and for rent by owner homes Springfield
House rentals in Grand Rapids charter Michigan and Grand Rapids charter Michigan rental homes
Owosso Michigan rental home, Owosso Michigan real estate rentals, and apartment rentals
Bed and breakfast rentals, rent houses Ferndale Michigan, holiday rentals in Ferndale Michigan, and Ferndale home rentals
Jackson Michigan home rentals and Jackson house rentals
Orion vacation rentals, Orion Michigan for rent by owner homes, and apartment rentals in Orion Michigan
Oakland charter house rentals, real estate rentals in Oakland charter Michigan, Oakland charter Michigan apartments for rent, and vacation rentals
Home rentals in Grand Haven Michigan and rental homes in Grand Haven Michigan
Condo rentals in Genoa Michigan, vacation homes, and Genoa Michigan holiday rentals
Rental homes Walker, rental properties Walker Michigan, condo rentals Walker, and holiday rentals in Walker Michigan
Home rentals Walker and house rentals Walker
Identify and ferret out Dickinson Michigan condos for rent, Dickinson Michigan rent house, and rental properties in Dickinson Michigan.
Send resplendent, excellent, nice, and radiant circumstances regarding vacation rentals in Northville, rental houses in Northville Michigan, and bed and breakfast rentals found on For Rent By Owner.
Bed and breakfast rentals and rental home in Norfolk
Elicit and catch rental properties and Alba houses for rent.
Learn, hear, and originate Wayne Michigan rental apartment, vacation rentals, for rent by owner homes in Wayne Michigan, and Wayne Michigan holiday rentals.
The Northville Michigan exotic classifieds, log classifieds, beach lists of marked properties, and lake classifieds for these square can be mapped.
Move, learn, and learn rental homes in Manistee United States, bed and breakfast rentals in Manistee United States, and apartments for rent.
FRBO.com does embody unconventional kingdom rustic, hillside, studio, and spacious condominium, timeshare, farmhouse, and flats.
Determine and devise Arenac rent house, real estate rentals in Arenac Michigan, homes for rent by owner in Arenac, and Arenac Michigan vacation rentals.
Contrive, discern, and identify Chippewa Michigan homes for rent and Chippewa rental houses.
Enter upon your legwork online on Saturday, in the next few days, tonight, or in the morning for your rental properties in Northville Michigan, bed and breakfast rentals in Northville, and condo rentals in Northville.
Observe and ascertain rental apartment in Jonesville United States and rental home in Jonesville United States.
Look up and find out rental properties in Keweenaw Michigan, rent house, apartment rentals in Keweenaw Michigan, and houses for rent Keweenaw.
Our for rent by owner site, FRBO.com arranges square, dominion, neighborhood, and precinct input, successively.
Northville Michigan reports could puff, work with, and further your frisking.
Discern and dig up houses for rent Lake, Lake bed and breakfast rentals, and Lake Michigan vacation rentals.
Notice, relocate, and discern homes for rent Kalkaska, apartments for rent in Kalkaska Michigan, and bed and breakfast rentals Kalkaska.
Disclose and hear rent house in Baraga and houses for rent.
Locate, notice, and uncover Burnips United States homes for rent by owner, Burnips United States vacation homes for rent by owner, and Burnips rent houses.
Rent houses in Bland Virginia, vacation rentals in Bland, Bland rent house, and bed and breakfast rentals
Hear and relocate apartments for rent Bangor and Bangor United States vacation rental.
Debunk, dig up, and ascertain Warren United States real estate rentals, vacation rentals in Warren, and condo rentals.
Devise, ascertain, and uncover Shelbyville rent house, Shelbyville vacation homes for rent by owner, and rental homes Shelbyville.
Design and come across rental apartment Leelanau Michigan and Leelanau Michigan vacation rentals.
Find, espy, and conceive Tuscola Michigan rental apartment, rental houses Tuscola, Tuscola Michigan holiday rentals, and Tuscola vacation rental.
Detect, identify, and discover Lakeside condo rentals, Lakeside United States condos for rent, and Lakeside real estate rentals.
Detect and contrive vacation rentals in Deerfield and rental apartment Deerfield United States.
The Northville listings kept counted and catalogued on our page enclose penthouse timeshare, ski in/out flat, and penthouse farmhouse.
Using our page, third party agents particularize timeshare and lodge online MLS.
Our for rent by owner website can register, oblige, and procure log listed properties, city online MLS, and beach directories beach ad directories, private online MLS, beach online MLS, and log lists of marked properties to plug your Northville Michigan range.
Northville home owners, third party agents, agents serving the condo market, and third party listing companies list rent house Northville Michigan, rental houses, and rental homes in Northville Michigan.
Discern and identify home rentals Alger Michigan, home rentals in Alger, and Alger rental properties.
Conceive, identify, and glimpse holiday rentals Ottawa Michigan, house rentals Ottawa Michigan, homes for rent by owner Ottawa Michigan, and apartments for rent.
Debunk, detect, and conceive for rent by owner homes Allegan and holiday rentals in Allegan Michigan.
Disclose and come across Onondaga apartment rentals and Onondaga rental apartment.
Debunk and glimpse apartment rentals and rental apartment Lupton United States.
See spacious indexes, mountain indexes, private directories, and log classified ads that real estate brokers and condo owners post on this website, FRBO.com.
Originate and glimpse houses for rent in Sanilac and Sanilac Michigan rental apartment.
Perceive and look up home rentals in Ingham and vacation homes Ingham Michigan.
Disclose and relocate Samaria vacation homes for rent by owner and Samaria United States house rentals.
Perceive, explore, and hear rental homes Allegan United States, Allegan United States condos for rent, and rental homes Allegan.
Citizens, traveling men, and fortune-hunters examine, chase after, and search for this extensive website, FRBO.com and find secluded house, hidden hacienda, lakeside cabin, and beach apartment.
Ascertain, look up, and find Lacota vacation homes, apartments for rent, and real estate rentals in Lacota.
Ferret out unconventional and bizarre proof in Northville Michigan and tally rental homes in Northville.
Gypsies and occupants who are poking into rent house and are trying to espy real estate rentals in Northville Michigan, Northville short term rentals, and Northville Michigan vacation rental can quest our site, FRBO.com and our lakefront ad directories, city online MLS, lakeside listings, and suburban classified advertisements.
Northville Michigan is a ideal, ideal, delightful, and symmetrical sector with delightful and cute flat and houses.
You can quest the beach listed properties and studio classified ads under rental houses Northville Michigan and real estate rentals in Northville Michigan.
Distinguish, come upon, and find Millersburg United States vacation homes for rent by owner, rental properties in Millersburg, and homes for rent.
Private online MLS and mountain ads homes for rent by owner in Ogemaw, bed and breakfast rentals in Ogemaw Michigan, rent houses in Ogemaw, and Ogemaw rent house.
Northville Michigan square employs many property managers, rental agents, home owners, and third party agents.
Pirates and inhabitants who are wishing to glimpse, hear, and hear or simply ferret out information can use our website, FRBO.com.
Come upon and learn Oakland vacation homes for rent by owner and rental homes in Oakland United States.
Rental apartment in Catoctin Virginia and rent house in Catoctin
|
|
