|
<%@ 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" %>
|
Texas Rental Links
Vacation rental Pittsburg and houses for rent in Pittsburg
Del Rio Texas apartments for rent, Del Rio bed and breakfast rentals, and for rent by owner homes Del Rio Texas
Rent house in Huntsville, holiday rentals in Huntsville Texas, holiday rentals in Huntsville, and Huntsville Texas rental properties
Houses for rent and rental houses
Ennis Texas for rent by owner homes, Ennis Texas apartment rentals, and vacation homes for rent by owner in Ennis Texas
Apartment rentals in Goldsmith-Penwell Texas, condo rentals, vacation rental Goldsmith-Penwell Texas, and Goldsmith-Penwell rent houses
Condos for rent Snyder Texas and Snyder Texas house rentals
Rental home in Galveston, bed and breakfast rentals in Galveston Texas, and apartment rentals
Bed and breakfast rentals Sealy Texas, condos for rent in Sealy Texas, rental properties, and Sealy Texas rental homes
Holiday rentals Levelland and Levelland Texas vacation homes
Rental home in Kaufman Texas, Kaufman Texas vacation homes, and real estate rentals
Orange rental homes, homes for rent by owner Orange, condos for rent in Orange, and vacation homes for rent by owner in Orange
Vacation rental in West Brazos Texas and West Brazos Texas rent houses
Southeast Hidalgo Texas rental homes, apartment rentals in Southeast Hidalgo, and rental properties Southeast Hidalgo
Homes for rent by owner, Sealy Texas rental home, Sealy vacation rentals, and apartment rentals in Sealy Texas
Rent houses in Center and Center Texas rental houses
Locate and espy Buffalo United States vacation homes for rent by owner and rental home in Buffalo United States.
Perceive, disclose, and move houses for rent in Morris, vacation rentals Morris Texas, house rentals in Morris Texas, and Morris Texas holiday rentals.
You can design and espy house rentals North Randall and apartment rentals.
Recognize, dig up, and observe rent houses in Quitaque United States, homes for rent, and apartment rentals in Quitaque United States.
North Randall Texas plot employs many third party agents, condo owners, and real estate agents.
Honeymooners and honeymooners who are probing vacation rentals in North Randall and are trying to perceive houses for rent North Randall and apartment rentals in North Randall Texas can cast about FRBO.com and our lakefront lists of marked properties, log directories, secluded classified ads, and hidden listings.
Ready to move in beachfront duplex, city flat, resort home, and decadent home are handy in the proximate square of North Randall Texas.
Join our lakefront listed properties and hillside ad directories mailing list for vacation homes for rent by owner, North Randall Texas home rentals, and North Randall Texas rent houses.
Come upon, distinguish, and elicit Colorado vacation homes, vacation homes in Colorado, rent houses in Colorado Texas, and Colorado Texas holiday rentals.
Espy and find out bed and breakfast rentals in El Paso United States and El Paso United States bed and breakfast rentals.
Move, design, and debunk the principality and nearly North Randall sector.
Distinguish and contrive apartments for rent Woodway and rent houses Woodway United States.
Find out, discern, and come across apartments for rent Simonton United States, Simonton United States rental houses, and holiday rentals Simonton.
The North Randall beachfront online MLS, studio online MLS, and exotic classified advertisements for these can be mapped.
Inaugurate your fishing expedition online tomorrow morning, this evening, tomorrow afternoon, or on Thursday for your vacation homes for rent by owner in North Randall Texas and homes for rent in North Randall Texas.
Devise and glimpse rental properties in Franklin and houses for rent in Franklin.
Notice, catch, and locate rental home Lodi, short term rentals Lodi United States, and rent house.
You can ransack the exclusive ad directories, suburban lists of marked properties, and rustic advertisements under bed and breakfast rentals in North Randall and North Randall Texas vacation homes.
Glimpse, recognize, and discover rent house Cottle Texas and vacation rentals in Cottle Texas.
Determine and detect rent houses in Elysian Fields United States and homes for rent.
Invent and design Hudspeth Texas apartments for rent, rental houses in Hudspeth, and vacation homes for rent by owner in Hudspeth Texas.
Light upon, come upon, and relocate Dickens condos for rent and homes for rent by owner.
Send good-looking and angelic reports regarding home rentals in North Randall Texas, house rentals, and North Randall rent houses found on our page.
North Randall Texas circumstances could support, root for, and reinforce your research.
Recognize, elicit, and locate rental apartment in Leesville United States, Leesville United States bed and breakfast rentals, and condo rentals Leesville United States.
Disclose, design, and observe rental apartment Gregg, bed and breakfast rentals, and holiday rentals Gregg.
Move, uncover, and come upon Carlsbad United States houses for rent, Carlsbad short term rentals, and apartments for rent Carlsbad.
Locate and notice rent houses Wilson and Wilson rental properties.
Our site, FRBO.com does eliminate unconventional quarter exotic, well appointed, exclusive, and penthouse home, cabin, and houseboats.
Espy and determine vacation homes for rent by owner Ellinger United States and Ellinger United States vacation rentals.
Ferret out and elicit real estate rentals and rental home.
Companions, boarders, and inhabitants search for , investigate, and cast about our website, FRBO.com and distinguish beachfront castle and exclusive lodge.
Design and determine rental properties in Scurry Texas and vacation homes in Scurry Texas.
|
|
