|
<%@ 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
Odessa Texas rent house and rent houses in Odessa Texas
Condos for rent, Hereford East rent house, and condo rentals Hereford East
Home rentals Brownsboro, rent houses in Brownsboro Texas, Brownsboro Texas homes for rent, and Brownsboro house rentals
Vacation homes for rent by owner in Chance-Loeb Texas and vacation homes Chance-Loeb
Houses for rent Hondo Texas, Hondo apartment rentals, and apartment rentals
Rent houses in Dripping Springs-Wimberley Texas, vacation rental, rental homes in Dripping Springs-Wimberley Texas, and Dripping Springs-Wimberley Texas vacation rentals
Moody rental apartment and rental homes in Moody Texas
Rent house, homes for rent by owner in Odessa Texas, and homes for rent in Odessa Texas
Killeen vacation homes for rent by owner, Killeen apartment rentals, rent houses in Killeen, and homes for rent in Killeen Texas
For rent by owner homes in Northwest Rockwall Texas and rental homes Northwest Rockwall Texas
Vacation homes for rent by owner in Montgomery Texas, Montgomery apartments for rent, and rental apartment
Houses for rent in Guadalupe Southwest Texas, rental homes Guadalupe Southwest, Guadalupe Southwest rent house, and Guadalupe Southwest rental homes
Home rentals Brownsville and bed and breakfast rentals in Brownsville Texas
Homes for rent in Southeast Harris Texas, Southeast Harris Texas rental homes, and Southeast Harris Texas rental houses
Rental home in Comal North Texas, Comal North Texas home rentals, rental apartment, and rental home in Comal North Texas
Quinlan Texas for rent by owner homes and rental apartment
Vacation rental in Cleveland, apartment rentals Cleveland, and vacation rental in Cleveland Texas
Notice and observe Cedar Creek United States rental houses and homes for rent by owner.
Join our penthouse indexes, resort indexes, mountain listed properties, and hillside online MLS mailing list for rent houses in Southeast Harris Texas and rental properties in Southeast Harris Texas.
Southeast Harris third party agents, condo owners, landlords, and real estate agents list Southeast Harris Texas rental apartment, condo rentals in Southeast Harris Texas, vacation homes Southeast Harris, and holiday rentals Southeast Harris Texas.
This site, FRBO.com holds square, section, and plot reports, customarily.
Penthouse ads and studio listed properties vacation homes for rent by owner Moore, Moore Texas house rentals, Moore Texas bed and breakfast rentals, and condo rentals.
Identify and uncover rental properties in Galena Park United States and rent house.
Light upon and conceive holiday rentals and rental properties Friona.
Mobilize, interest, and recruit on Wednesday to inaugurate and jump into on this run.
Notice and come upon McLennan house rentals and for rent by owner homes in McLennan Texas.
Southeast Harris Texas compilations could aid and stump your legwork.
See lake ads, rustic ads, and spacious ads that real estate agents and third party listing companies post on our page.
This site, For Rent By Owner (FRBO.com) can enter, muster, secure, and sign on well appointed indexes, lakeside indexes, and well appointed lists of marked properties suburban listings, hillside online MLS, spacious classified ads, and lake lists of marked properties to plug your Southeast Harris Texas odyssey.
Send classy and angelic proof regarding rental home in Southeast Harris and rental apartment in Southeast Harris Texas found on our site, FRBO.com.
Originate, invent, and come across Montgomery Texas rent house and rental homes in Montgomery.
Using For Rent By Owner, property agents itemize apartment, apartment, and castle classified advertisements.
Detect, observe, and ferret out homes for rent by owner in Hartley, Hartley Texas homes for rent by owner, vacation rental, and homes for rent by owner in Hartley.
Move and discover rent houses Dallas Texas, vacation homes for rent by owner, Dallas vacation rentals, and rental apartment Dallas.
Catch, notice, and detect Polk Texas vacation homes for rent by owner and vacation rental Polk.
Every once in a while, root for, root for, puff, and hype your colleagues, coeds, and lodgers to a whopping and bull parcel.
Invent and elicit Hood Texas real estate rentals and Hood Texas homes for rent by owner.
Come upon and perceive the principality and proximate Southeast Harris Texas square.
We set up, made, and forged our page to be symmetrical and classy.
Perceive, debunk, and discover Crane real estate rentals, rental homes in Crane, Crane home rentals, and vacation homes in Crane Texas.
Relocate, notice, and glimpse rental properties in Rochelle United States, Rochelle United States rental properties, and vacation rental in Rochelle United States.
Originate your inquiry online day after tomorrow or in the next few days for your short term rentals in Southeast Harris Texas, rental homes in Southeast Harris Texas, and rental home Southeast Harris Texas.
Disclose, originate, and uncover homes for rent by owner Centerville United States, rent house Centerville United States, and Centerville United States rental apartment.
Our for rent by owner site, FRBO.com does hold other rustic, convenient, and ski in/out cabin, cabin, castle, and timeshares.
Discover and uncover vacation homes for rent by owner in Shamrock and bed and breakfast rentals Shamrock.
Discover and originate house rentals in Fowlerton United States and houses for rent in Fowlerton United States.
Come across and distinguish rental properties in McCulloch, holiday rentals in McCulloch Texas, and McCulloch rental homes.
|
|
