Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:57:28.467' ,`MLSNumber` = '36898025' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.561089' ,`Longitude` = '-95.565520' ,`PhotoCount` = '44' ,`PostalCode` = '77358' ,`RoomCount` = '4' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Charred Oak' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bed 2 bath home sits on 2 unrestricted acres! Interior features include a large living area that opens up to the kitchen/dining area, home office/study, massive pantry, a wood-burning fireplace + generously sized bedrooms! The kitchen boasts ample storage and cabinet space and a breakfast bar! In the primary bedroom, is an en-suite bath boasting dual sinks + an abundance of space. Exterior features include a shop with electricity, a massive covered front porch, covered RV parking with electricity, and 2 partially cleared acres. This home is priced to sell and won\'t last long! Schedule a private tour today!' ,`Acres` = '2.0079' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FORGOTTEN FOREST - SEC 3, BLOCK 1, LOT 25, & SEC 1, BLK 3, L' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '87466' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forgotten Forest - Sec 3' ,`TaxAmount` = '865' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587748' WHERE `Matrix_Unique_ID` = '208035069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:22:01.937' ,`MLSNumber` = '17970240' ,`ListAgentFullName` = 'Rhonda Berry-Pohlman' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703133' ,`Longitude` = '-95.852397' ,`PhotoCount` = '45' ,`PostalCode` = '77441' ,`RoomCount` = '12' ,`ListPrice` = '588950.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Mountain' ,`StreetNumber` = '27431' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAGNIFICENT Trendmaker home in Cross Creek Ranch featuring 4 bedrooms (2 DOWN), 3.5 bath, 2.5 car attached garage located on a fantastic DOUBLE CUL-DE-SAC GREENBELT LOT with no back or right side neighbors & easy access to walking trails! Huge front porch w/double doors positioned on the side for extra privacy! Rich WOOD FLOORS greet you & continue through this flowing open concept floor plan. Formal dining room w/coffered ceiling, study behind French doors & lovely gourmet kitchen w/large granite island, breakfast bar & SS appliances. Family room features beautiful ceiling high stone fireplace! Primary bedroom w/whirlpool tub in en-suite bath. Game room & media room upstairs! Venture out back to the covered patio & oversized back yard where you’ll have a clear view of Texas sunsets! Quiet neighborhood with low traffic on the street and just a short walk to Flewellen Creek pool, soccer field & dog park! Katy ISD! This master planned community is full of family friendly activities!' ,`Acres` = '0.2064' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 1, BLOCK 1, LOT 21' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '12244' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587748' WHERE `Matrix_Unique_ID` = '210016827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:35:13.033' ,`MLSNumber` = '7976958' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469909' ,`Longitude` = '-95.463677' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '337690.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Rubia' ,`StreetNumber` = '7815' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Kingston Plan with Elevation L, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\n Listing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R HORTON, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667587749' WHERE `Matrix_Unique_ID` = '210878640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:36:45.883' ,`MLSNumber` = '8081728' ,`ListAgentFullName` = 'Rachel Lopez' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769762' ,`Longitude` = '-95.308744' ,`PhotoCount` = '38' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Woolworth' ,`StreetNumber` = '1034' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '981' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Reduced charming home in the up & coming Denver Harbor community! This home immediatley welcomes you in with a large front porch area! Featuring 2 bedroom,1 bth, w/ 981 sqft of living space. This homes has original solid hardwood floors throughout the living & bedroom areas! The spacious kitchen has tile flooring,large solid wood cabniets, & a tile countertop!! 2 large bedrooms both have updated ceiling fans! Bright updated bathroom offers lots of space! Several windows throught the home to allow natural light! Washer/Dryer connections in large laundry area, leads into bounus room, use as bedroom or small business office,or den! The home sits on a 6250 sqft lot which allows for plenty yard space for outdoor living & entertaining.Fenced home includes long driveway entrance! Motivated Seller! Great Location! Minutes from Downtown,UofH,Minute Maid Park, & the Toyota Center. Easy access to I-10,I-45,& 59.MAKE YOUR APPOINTMENTS TODAY! Plumbing updated. Well Maintained! Wont Last Long!' ,`Acres` = '0.1435' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 31 & 32 BLK 17 DENVER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver' ,`TaxAmount` = '2565' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587749' WHERE `Matrix_Unique_ID` = '211140789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:40:07.240' ,`MLSNumber` = '7236951' ,`ListAgentFullName` = 'Amy Vanterpool' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136872' ,`Longitude` = '-95.061072' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Martes' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All one level three bedrooms two bathrooms, canal front home in Terramar Beach. Windows have storm shutters you will really enjoy all the deck and patio space as well as the downstairs storage and yard area. Terramar community offers a pool, boat ramp, beach access, frisbee golf course, and pavilion area. Terramar is close to Sea Isle restaurant, marina, & stores. Buyer to verify room dimensions and details of the property. Everything stays with the sale of the property. Property is being sold AS IS.' ,`Acres` = '0.123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 6 BLK 8 TERRAMAR BEACH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terramar 4' ,`TaxAmount` = '7438' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587749' WHERE `Matrix_Unique_ID` = '211902844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:22:32.603' ,`MLSNumber` = '4713247' ,`ListAgentFullName` = 'Rhonda Berry-Pohlman' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732305' ,`Longitude` = '-95.862773' ,`PhotoCount` = '36' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '478850.00' ,`Status` = 'Active' ,`StreetName` = 'Asher Falls' ,`StreetNumber` = '28406' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS 1 story 2017 Highland Homes beauty in Cross Creek Ranch features gorgeous brick front elevation, 4 bedrooms, 3 full baths & 2 car garage! Zoned to KATY ISD! GREAT LOCATION - neighborhood park is just down the street & Campbell Elementary is walking/biking distance! This home showcases elegant architecture and a wonderful open concept design. Front foyer welcomes you w/a high ceiling & beautiful wood-look tile flooring. Continue to the private study w/French doors, open concept dining room & inviting family room w/wall of windows making this home light & airy! The Chef in your family will love the gourmet kitchen providing gorgeous QUARTZ counters including a large island w/breakfast bar, SS appliances and pendant & recessed lighting! Primary suite has garden tub in en-suite bath! Step out back to the covered patio – perfect for family cook-outs or relaxing in the evenings! Washer, dryer, counter depth fridge included. This is a place to call home & create cherished memories!' ,`Acres` = '0.1675' ,`Area` = '36' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK FALLS AT CROSS CREEK RANCH SEC 9, BLOCK 2, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7430' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '11809' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587749' WHERE `Matrix_Unique_ID` = '211990569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:34:58.963' ,`MLSNumber` = '23622799' ,`ListAgentFullName` = 'Anja Drewes Neidhardt' ,`ListOfficeName` = 'Anja DrewesProperties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583315' ,`Longitude` = '-95.637012' ,`PhotoCount` = '40' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Marigold' ,`StreetNumber` = '17419' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 4 bedroom home zoned to best schools in Sugar Land for sale. This a great opportunity to access a neighborhood that is high in demand. Home has great layout with premier bedroom downstairs, large ensuite bathroom with his and her closet. Formal dining room, family room with fireplace is open to the kitchen. Upstairs 3 bedrooms and game room. Beautiful large backyard with no back neighbors. Minutes away from the First Colony mall and 59 freeway. No flooding. Priced for quick sale to reflect the home need some updates.' ,`Acres` = '0.1832' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LEXINGTON MEADOWS SEC 1, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Meadows' ,`TaxAmount` = '7752' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587749' WHERE `Matrix_Unique_ID` = '212091618' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:48:04.667' ,`MLSNumber` = '68739294' ,`ListAgentFullName` = 'Christina Pizzitola' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689881' ,`Longitude` = '-95.480095' ,`PhotoCount` = '45' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Edith' ,`StreetNumber` = '5411' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5411 Edith Street has everything you have been looking for, and more! This beautiful 2007(per HCAD) Brookstone Home situated on a 10,500 square foot lot (per HCAD) features 5-bedrooms, 4.5-bathrooms, TWO utility rooms and a game room! Upon entry into this 5,353 square foot house (Per HCAD), you’ll find the gorgeous office/library with newly installed windows, formal dining room, and the perfect wine room for entertaining! The Kitchen features a large island & breakfast area, which then opens to the Family Room where you will enjoy looking out onto the expansive backyard and gated pool. The large Primary Suite features a separate sitting area and Primary Bathroom which offers dual vanity sinks, a walk-in shower, soaking tub, and a walk-in closet with built-ins. The property has a two-car garage, and a two-car porte-cochere. Near Meyerland Shopping, Downtown and the Medical Center! Come see this fabulous home today! All info per seller' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'BROOKSTONE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 BRAES VIEW TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braes View Terrace' ,`TaxAmount` = '22934' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587750' WHERE `Matrix_Unique_ID` = '212421136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:40:11.860' ,`MLSNumber` = '3994613' ,`ListAgentFullName` = 'Anita Cameron' ,`ListOfficeName` = 'EOC Realty Associates LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579124' ,`Longitude` = '-95.013959' ,`PhotoCount` = '32' ,`PostalCode` = '77586' ,`RoomCount` = '14' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Plymouth Rock' ,`StreetNumber` = '1321' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lowest price per sq foot in Mystic Village!!*Texas Size home in much desired Mystic Village*Over 4,000 sq ft*Low tax rate*Never flooded*Beautiful home with soaring 2 story ceilings in family room*Family room with fireplace*Open concept kitchen with island & breakfast bar & breakfast rm*Separate living/dining room*Game room 2nd floor*Home office/study 1st floor*Primary bedroom down with ensuite br*Separate shower, soaking tub & double sinks*4 great sized bedrooms up (ck rm sizes)*Media room 2nd floor*Oversized 2 car garage*Workshop w/sink*Big yard w/fully fenced BY w/fence replaced in 2019*New roof 2018*Recently painted interior*Updated 2nd floor bathroom is gorgeous & was done this yr*All new light fixtures/ceiling fans & hardware on doors*New plumbing fixtures throughout*New hot water heater*Half bath recently updated*Location is everything, this house is not exception, subdivision park on Lake Mija*Close to the Kemah Boardwalk*Desirable CCISD*Please call for your private viewing.' ,`Acres` = '0.219' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 7 MYSTIC VILLAGE AT LAKE MIJA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mystic Village At Lake Mija' ,`TaxAmount` = '8592' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587750' WHERE `Matrix_Unique_ID` = '212468662' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212663411','1667587750','212663411','2022-11-04T07:24:13.487','25927226','David Levin','RE/MAX Grand','','','30.067324','-95.202606','13','77339','8','329000.00','Active','Woodbridge','4303','Drive','Humble','2','0','4','2163','Single-Family','','0.2176','32','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Kingwood West','Central Gas','0','LT 6 BLK 41 HUNTERS RIDGE VILLAGE SEC 3','Corner,Wooded','9477','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Electric Range','','Composition','29 - Humble','BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD HIGH SCHOOL','CREEKWOOD MIDDLE SCHOOL','Appointment Required','Seller','1','Traditional','Hunters Ridge Village','5484','2.5839','Public Sewer,Public Water','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:31:59.490' ,`MLSNumber` = '41731121' ,`ListAgentFullName` = 'Firely Vincent' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843109' ,`Longitude` = '-95.723939' ,`PhotoCount` = '48' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Lamppost Hill' ,`StreetNumber` = '5030' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5030 Lamppost Hill Ct! This stunning 3,220 sq ft 2-story home boasts with 4 bedrooms, 2 1/2 bathrooms, and features a ton of beautiful upgrades, not to mention the HUGE upstairs GAMEROOM, an incredible MEDIA ROOM, and an amazing BONUS ROOM that would be perfect for a study! Featuring beautiful stainless steel appliances, wine cooler fridge under countertop, modern fixtures, a spacious covered back patio, above ground pool and so much more. New roof & heater both installed less then a year ago! With an amazing location featuring easy access to 99 and I-10, this stunning home has everything you could ever want or need! This gorgeous home won\'t last long, schedule your private showing today!' ,`Acres` = '0.1102' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 RICEWOOD VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village Sec 2' ,`TaxAmount` = '7481' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667587750' WHERE `Matrix_Unique_ID` = '212826798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:19:04.147' ,`MLSNumber` = '72834051' ,`ListAgentFullName` = 'Gopi Khande' ,`ListOfficeName` = '99 Mansions Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535501' ,`Longitude` = '-95.613147' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '17' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Felled Timber Springs' ,`StreetNumber` = '6322' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Georgeous 3 year old home features 2 story ceilings from foyer through family room creating an open concept. Massive white kitchen with enough storage space and walk in pantry. Main level features home office space, formal dining room, and stunning coffered ceiling family room. This 2 story luxury home boasts 6 bedrooms 3 car garage. Primary suite and secondary bedroom on the main level. Upstairs are 4 additional bedrooms, and a media room, for fun movie nights. This property has plenty of yard space for a pool and much more.' ,`Acres` = '0.2541' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SECTION 18-B, BLOCK 4, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11068' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'AVALON AT RIVERSTONE' ,`TaxAmount` = '16000' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667587750' WHERE `Matrix_Unique_ID` = '212950157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:14:03.137' ,`MLSNumber` = '78274038' ,`ListAgentFullName` = 'Christopher Ballew' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.173558' ,`Longitude` = '-94.997230' ,`PhotoCount` = '30' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Beach' ,`StreetNumber` = '4003' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1423' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4003 Indian Beach Dr. Step out onto the deck to enjoy the fresh coastal breeze and wildlife brought in by the pond located on the property. The beach is just under a 1/2 mile away. The downstairs area features plenty of space for entertaining including louvers for privacy. This 3 bedroom 2.5 bath home is on over an acre of property and will make a great primary, secondary, or investment home. The home features storm windows with transferable warranty on all hard to reach locations and easy to install storm shutters for all of the windows on the deck. The downstairs has break away louvers to increase privacy on the bottom level. Home is wired for a generator. The neighborhood has a swimming pool, 2 tennis courts, and a fishing pier. New carpet Oct. 2022' ,`Acres` = '1.154' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 52 BLK 3 INDIAN BEACH SEC 3' ,`LotDesciption` = 'Water View' ,`LotSize` = '50268' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '393' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Beach' ,`TaxAmount` = '7972' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587750' WHERE `Matrix_Unique_ID` = '213231710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:05:48.210' ,`MLSNumber` = '50813797' ,`ListAgentFullName` = 'Toyia Chenevert' ,`ListOfficeName` = 'Re/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503740' ,`Longitude` = '-95.399121' ,`PhotoCount` = '27' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Palomar' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This magnificently well maintained 4 bedroom 2.5 bath 2 Story home in Rodeo Palms has both charm and elegance that greet you at the front door. The open and airy family room has tons of natural light all open to the gourmet kitchen equipped with stainless steel appliances, tons of cabinets for storage, tile backsplash and an over-sized island which makes it the perfect spot for entertaining. Unwind in your luxurious Primary Retreat with a beautiful bath featuring dual sinks, soaking tub, separate shower & walk-in closet. Upstairs where you will find 3 secondary bedrooms, full bath and spacious game room with study nook. Not to mention NEW roof, NEW carpet, FRESH paint, 2017 HVAC system, sprinkler system and NO back neighbors!! You\'ll Love the convenience of nearby shopping, restaurants, and close proximity to 288 and Beltway 8. Community amenities include a clubhouse, pool and beautiful walking trails. You don\'t miss this amazing opportunity!' ,`Acres` = '0.1528' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS, PALM COURT SEC 1 (A0459 & A0299)(MANVEL) BLK 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Court Sec 1' ,`TaxAmount` = '9509' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587751' WHERE `Matrix_Unique_ID` = '213253304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:29:19.080' ,`MLSNumber` = '2451234' ,`ListAgentFullName` = 'Yolanda Whitlock' ,`ListOfficeName` = 'SOS Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.351048' ,`Longitude` = '-95.549608' ,`PhotoCount` = '43' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 528' ,`StreetNumber` = '16422' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED approx. 900 ft of FM 1462 frontage Rd (commercial or residential) Just over 8.5 acres bring horses, dogs, chickens, and even ducks. Scenic views of the TX sky & beautiful mature trees of this place you are sure to fall in love with. The rustic cozy home features beautiful epoxy floors throughout and 6 panel knotty pine doors. Relax and enjoy the views outside from the living room while sitting in front of the fireplace that is adorn with stone & TX split cedar mantel. Primary bedroom boast the same see-through fireplace and two petrified wood sinks in the bathroom. Maybe you want to sit out in the front porch and enjoy the water view of the pond and take in the fresh air. You can certainly do that here. There is plenty of room for horses in a 76\'x26\' barn and 2 tack rooms. Dogs, have their own area 35\'x8\' covered dog kennel. Let\'s not forget the 60\'x40\' detached workshop connected to a 60\'x20\' mancave with a full bathroom. Two car A/C\'d garage. Country living at it\'s best!' ,`Acres` = '8.542' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0125 A ROBINSON BLOCK A TRACT 2-2A (BRAZOS LANDING TRACT 3)' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '372090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'A Robinson' ,`TaxAmount` = '8421' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587751' WHERE `Matrix_Unique_ID` = '213259360' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:07:06.943' ,`MLSNumber` = '30902780' ,`ListAgentFullName` = 'Tai Dinh' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = 'Kirsstien Delossantos' ,`SellingOfficeName` = 'Go Real Estate' ,`Latitude` = '29.708509' ,`Longitude` = '-95.574555' ,`PhotoCount` = '26' ,`PostalCode` = '77072' ,`RoomCount` = '7' ,`ListPrice` = '249990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bandlon' ,`StreetNumber` = '11111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, beautiful one story home with 3 beds, 2 baths in subdivision of Brays Village. Double front door. Upon entry the foyer opens up to a large atrium allowing lot of natural sunlight. Tile throughout the house, no carpet. Spacious family room for gathering and is accented with brick fireplace. Big kitchen offers large island, stainless steel appliances. Kitchen opens to dining room and surround with many windows. Master suite includes spacious living space, sitting area viewing atrium and have door to access to back yard. Large backyard for your entertainment. Not flooded. Close to West park, beltway 8, hwy 6, 59. Fridge, washer, dryer stay. House is ready to move in.' ,`Acres` = '0.1295' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BRAYS VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5639' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Village Sec 04' ,`TaxAmount` = '3719' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587751' WHERE `Matrix_Unique_ID` = '213481439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:50:26.387' ,`MLSNumber` = '63234696' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743698' ,`Longitude` = '-95.568840' ,`PhotoCount` = '15' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia' ,`StreetNumber` = '10826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Lakeside Estates! This One-Story Colonial offers Approx. 2393 SF with 4 bedrooms, 2.5 baths and a 2 car garage. The Property features a Family-size Den, traditional Formals, high beam ceilings and wood floors. Beautifully update home, with private pool. Kitchen has beautiful counter tops and stainless steel appliances. Convenient west side location for commuting to school, work, entertainment & shopping! Home was high and dry during Harvey. A must see!' ,`Acres` = '0.2039' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 6 LAKESIDE ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates Sec 03' ,`TaxAmount` = '9133' ,`TaxRate` = '2.5264' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587751' WHERE `Matrix_Unique_ID` = '213487757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:52:00.673' ,`MLSNumber` = '64833133' ,`ListAgentFullName` = 'Gretchen Barrilleaux' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728156' ,`Longitude` = '-95.810509' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Cole Trace' ,`StreetNumber` = '26410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Come see this FANTASTIC 4 bedroom/3.5 bath Cinco Ranch Beauty located in the heart of Cinco Ranch! A darling front porch greets you home! Rich wood floors throughout (tile in the wet areas) no carpet! The island kitchen boast granite, subway marble tile backsplash, gas cooking, custom painted 42\" cabinets and undercabinet lighting! Open to to the family room with cozy gas fireplace! Private owners retreat with dual sinks, soaking tub, separate shower and walk-in pantry. Upstairs you will find 3 spacious bedrooms (one en suite), 2 baths and a game room! Extended covered patio with lush landscaping and no back neighbors! Community park behind home! Close to schools, amenities and shopping! Easy access to freeways! AWARD WINNING Katy ISD schools!' ,`Acres` = '0.137' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 32, BLOCK 1, LOT 32' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5969' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '7542' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587752' WHERE `Matrix_Unique_ID` = '213655242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:04:59.057' ,`MLSNumber` = '40566632' ,`ListAgentFullName` = 'Carlos Nava' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656628' ,`Longitude` = '-95.150593' ,`PhotoCount` = '39' ,`PostalCode` = '77505' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Butterfly' ,`StreetNumber` = '5914' ,`StreetSuffix` = 'Circle' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Best House in the Neighborhood for the Investment!\r\nCompletely Remodeled 1st floor with some extras like a larger Primary Walk in Closet, large soaker tub, half bath added in the garage, additional outlets in garage, retiled fireplace just for starters. Then we go upstairs where the bath was completely redone with larger soaker tub and new vanity with extra cabinet space. New floors throughout, NO CARPET! The backyard has been transformed into your private oasis; The pool has been completely changed with new tile, fountains, and finishing. The large shed stays. Even with the large pool, you still have yard to play, run the puppy, or set up a playground. Not to mention the larger second story deck that can be used for those oversized parties along with the covered patio below. This house has been prepared to become your Home.' ,`Acres` = '0.1446' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 55 BLK 4 COUNTRY BRIAR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Briar Sec 01' ,`TaxAmount` = '4709' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587752' WHERE `Matrix_Unique_ID` = '213665261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:51:22.843' ,`MLSNumber` = '29347426' ,`ListAgentFullName` = 'Isela Truong' ,`ListOfficeName` = 'Terramont Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368054' ,`Longitude` = '-95.608529' ,`PhotoCount` = '45' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Springs Edge' ,`StreetNumber` = '266' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN House Sat 11/5 1pm-4pm! Stately home sits on a corner, cul-de-sac lot with views of the golf course. Roof is only 6 years old and the home comes with a whole house Generac Generator! Recently updated with New Quartz countertops, backsplash, stove with wifi, pop up exhaust vent, stainless steel sink, fresh paint and carpet, all new faucets and LED lighting. Simply Charming home, light and bright, located on one of the nicest streets in April Sound. Pride of ownership shows in all the surrounding homes. Covered balcony off the primary bedroom with stairs to access the patio below. Kitchen boasts a double bar for additional seating on both ends. Owner is offering $500 towards a home warranty of your choice. Schedule your tour today!' ,`Acres` = '0.3036' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 01, BLOCK 5, LOT 51' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '13223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 01' ,`TaxAmount` = '5587' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587752' WHERE `Matrix_Unique_ID` = '213668641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:25:53.447' ,`MLSNumber` = '88464975' ,`ListAgentFullName` = 'Glendi Ramos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678983' ,`Longitude` = '-95.824795' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '1999999.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Lake' ,`StreetNumber` = '10511' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5015' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom 3 bath residence on a 2.5 acre lot! Featuring an open concept kitchen equipped with a commercial built in fridge. Plenty of prep and pantry space. Spacious laundry room. A grand game room perfect for entertaining. The additional building features 1600sqft that could be used as commercial or residential purposes. Schedule your appointment today!' ,`Acres` = '2.5' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GASTON-FULSHEAR CORP, Lot 33, ACRES 2.5, (Pt) Tract 40, A-26' ,`LotDesciption` = 'Other' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gaston-Fulshear Corp' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587752' WHERE `Matrix_Unique_ID` = '213779070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:25:12.687' ,`MLSNumber` = '76806585' ,`ListAgentFullName` = 'Connie Mundy' ,`ListOfficeName` = 'Coldwell Banker Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051089' ,`Longitude` = '-95.931932' ,`PhotoCount` = '37' ,`PostalCode` = '77484' ,`RoomCount` = '5' ,`ListPrice` = '267000.00' ,`Status` = 'Active' ,`StreetName` = 'Orange' ,`StreetNumber` = '3050' ,`StreetSuffix` = 'Street' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1563' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath home with split floor plan is move in ready. Located in a quiet neighborhood just minutes from Hwy 290 and local shopping. As soon as you walk up to this home you are welcomed a massive live oak tree. Kitchen features a double oven and electric cooktop. The living area has an open floor plan with high ceiling. Large fenced backyard. Updates include: Granite counter tops in kitchen, fresh interior paint, new windows throughout with transferable warranty, updated bathrooms with granite counter tops and tiled shower.' ,`Acres` = '0.32' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S836000 TRANQUILITY PARK LOT PT 5 & 6 ACRES .32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tranquility Park' ,`TaxAmount` = '4714' ,`TaxRate` = '2.6131' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667587752' WHERE `Matrix_Unique_ID` = '213786622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:13:32.173' ,`MLSNumber` = '48554465' ,`ListAgentFullName` = 'Kim Palomino' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201679' ,`Longitude` = '-95.446416' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Threadtail' ,`StreetNumber` = '8109' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive Highland Homes Middleton plan on a cul-de-sac street in the master planned community of Harpers Preserve adjacent to The Woodlands and zoned to Conroe ISD. This home has it all including a backyard paradise with pool, gazebo and large covered patio. With 5 bedrooms, study, formal dining, game room, media room and oversized 3-car garage there is nothing this house does not offer. Two bedrooms down, including the primary bedroom and a full bath. The main living area, both downstairs bedrooms, and the office have engineered hardwood. Upstairs are three more bedrooms, two full baths, game room and media room. This special home will not last long! The Upgrade List and Survey are in the Document Section.' ,`Acres` = '0.211' ,`Area` = '15' ,`BuilderName` = 'Highland' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572700 - HARPER\'S PRESERVE 01, BLOCK 8, LOT 51' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '15947' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587753' WHERE `Matrix_Unique_ID` = '213813119' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:04:49.293' ,`MLSNumber` = '30595808' ,`ListAgentFullName` = 'Maihuong Nguyen' ,`ListOfficeName` = 'Precious Realty & Mortgage' ,`SellingAgentFullName` = 'Athena O\'Gara' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.758951' ,`Longitude` = '-95.869824' ,`PhotoCount` = '42' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '660000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Parker Ridge' ,`StreetNumber` = '28943' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, beautiful 2 story home w 4 beds, 3 full baths & a half bath, study room, 2 car tandem garage. Beautiful elevation w stucco, 4 sided brick at corner lot. Wood floor throughout except for carpet in master bedroom on first level. Beautiful kitchen features gray cabinetry w plenty of cabinets, quartz countertop, stainless steel appliances: vent hood, gas cooktop, built in oven and microwave, dishwasher, fridge. Spacious family room with high ceiling, large windows with natural light. House comes with over $5k roll up curtains. Family room opens to breakfast area and kitchen. The master ensuite features a spacious living space, separate garden tub and shower, walk in closet, double vanities. Big game room and other 3 bedrooms on second level. Fridge, washer, dryer stay. Community amenities offer pool, tennis courts, lakes and trails, fitness center, clubhouse and more. Lamar Consolidated ISD. Never flooded. Close to I-10 and 99. Lot of shopping nearby. Low tax rate. Ready to move in.' ,`Acres` = '0.2157' ,`Area` = '30' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 19, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne West Sec 19' ,`TaxAmount` = '1406' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667587753' WHERE `Matrix_Unique_ID` = '213818584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:24:39.490' ,`MLSNumber` = '17529371' ,`ListAgentFullName` = 'Anja Drewes Neidhardt' ,`ListOfficeName` = 'Anja DrewesProperties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647955' ,`Longitude` = '-95.728708' ,`PhotoCount` = '42' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Cane Lake' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in sought after Waterside Estates subdivision! Spacious 4 bedroom/2 bath/2 car garage. Open floorplan with huge living room, vaulted ceilings, formal dining, lots of closet space . Ready for you to move in with brand-new flooring (carpet with upgraded pad and luxury vinyl plank ), all freshly painted, incl trim and doors, new doorknobs, new front and rear door, new dual flush toilets, new kitchen faucet, new range hood. 2019 updates included: new hvac, water heater, garbage disposal, garage door and motor. Waterside Estates offers a beautiful fishing lake, walking trails, parks, community tennis courts and pool with kiddie splash pad. Zoned to Fort Bend ISD award-winning schools and easy commute make this a great place to call home! Easy access to 99, nearby shopping, dining, and entertainment. The Lifestyle You’re Looking For!' ,`Acres` = '0.135' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 9, BLOCK 1, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates' ,`TaxAmount` = '4741' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587753' WHERE `Matrix_Unique_ID` = '213910743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:56:47.940' ,`MLSNumber` = '18488569' ,`ListAgentFullName` = 'Joshua Pedroso' ,`ListOfficeName` = 'Generation Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701675' ,`Longitude` = '-95.746262' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Tallow Knoll' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLERS ARE WILLING TO BUY DOWN BUYER\'S INTEREST RATE with an accepted offer!\r\nWelcome home to this HIDDEN GEM located in Lakemont. HUGE CUL-DE-SAC LOT!! BRAND NEW ROOF (2022) Tile throughout the WHOLE house, beautiful chandeliers in entry and dining, marble countertops with tile backsplash in the kitchen, top-of-the-line stainless Kitchen Aid appliances (with a double oven!), digital thermostat, Gameroom has been utilized as a 4th bedroom, large covered patio with a screened area for storage, sprinkler system and more! HOME HAS NEVER FLOODED!!' ,`Acres` = '0.2674' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT SEC 2, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8215' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587753' WHERE `Matrix_Unique_ID` = '213980986' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213985350','1667587754','213985350','2022-11-04T07:02:52.827','79652416','Ruben Chapa','Texas Signature Realty','Ruben Chapa','Texas Signature Realty','29.643415','-95.144662','17','77505','5','200000.00','Option Pending','Italy','4423','Lane','Pasadena','2','0','3','1193','Single-Family','Looking for a home for the holidays? Look no further then the charming neighborhood of Fairmont Estates! This lovely home awaits to impress you with its beautiful features. The kitchen is a cook\'s dream with white cabinets, quartzite countertops, and brand new stainless steel appliances. The spacious primary bedroom, along with 2 secondary bedrooms, and 2 bathrooms are spread out across this carefully crafted home. The inside is just as great as the out with a spacious backyard, beautiful covered patio with a built in bluetooth speaker system perfect for entertaining family and friends. Also, how about the amazing public schools in the area? Zoned to the best schools in Pasadena, including two \"A\" rated campuses, this is a perfect choice! It\'s all about location, and this home doesn\'t disappoint. Fairmont Shopping Center, HEB, Walgreens, Starbucks, and so much more located within 1 mile! This is the perfect place to call home, Call today to schedule a private tour!','0.1377','6','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','1','Pasadena','Central Gas','0','LT 28 BLK 6 FAIRMONT ESTATES SEC 3 R/P','Subdivision Lot','6000','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','TURNER ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Fairmont Estates Sec 03 R/P','4036','2.6514','Public Sewer,Public Water,Water District','1979','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:36:46.087' ,`MLSNumber` = '59397651' ,`ListAgentFullName` = 'Lori Meadows' ,`ListOfficeName` = 'Accustar Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030157' ,`Longitude` = '-95.520678' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Pines' ,`StreetNumber` = '17215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updates Galore! 4 bedrooms, 2.5 bath with 2 car detached garage. This house has been completely updated and turn key ready! Updated lighting throughout, as you walkthrough the door you walk into a spacious living room with wood like tile throughout the entire first floor with 5 1/2 inch baseboards. Entertain your guests and family in your formal dining room or create a play room or den for the kids. This house has a grandeur look with updated door knobs, ceiling fans, updated lighting. Kitchen with all updated appliances, granite counter tops, subway tile backsplash. Keep your family cool with the AC unit recently installed. As you walk up the stairs, feel the soft updated carpet throughout the second floor. Fresh paint inside and out. Roof installed 9/22. Klein schools.' ,`Acres` = '0.1616' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 8 017*O0118825-001-008-024 OAKWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '492' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Glen Sec 01' ,`TaxAmount` = '4644' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587754' WHERE `Matrix_Unique_ID` = '213992227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:05:47.167' ,`MLSNumber` = '66666080' ,`ListAgentFullName` = 'Felecia Fernandez' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616417' ,`Longitude` = '-95.394832' ,`PhotoCount` = '29' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Hillock' ,`StreetNumber` = '12511' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour the most desirable floor plan in City Park! This home features 4 full bedrooms with Primary Suite on the first floor, 3 additional-spacious bedrooms upstairs, private office and a game room! One of the most popular features is the oversized island in the center of the home with plenty of space for dining and entertaining. Recent exterior paint (2022). Other important features include: high ceilings, walk-in closets, sizable laundry room, great backyard with covered patio. Residents enjoy the community walking trails, serene lake, adventurous playgrounds and well kept grounds! Enjoy suburb living inside the city with easy access to 288 S, Sam Houston Tollway and Hwy 6.' ,`Acres` = '0.132' ,`Area` = '3' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 CITY PARK SOUTH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park South' ,`TaxAmount` = '7785' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587754' WHERE `Matrix_Unique_ID` = '213996835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:58:55.230' ,`MLSNumber` = '29967555' ,`ListAgentFullName` = 'MariaLeticia Zamora' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894666' ,`Longitude` = '-95.225273' ,`PhotoCount` = '21' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '193000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenloch' ,`StreetNumber` = '11842' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely Home with a manicured backyard. Tile throughout the entire home. This is a very well-kept home; must see to appreciate. Vaulted ceilings with a brick wood burning fireplace. Easy access to the Beltway! Call to make an appointment!' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 GREENSBROOK SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greensbrook Sec 01 R/P' ,`TaxAmount` = '1813' ,`TaxRate` = '3.1593' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587754' WHERE `Matrix_Unique_ID` = '213997635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:52:48.733' ,`MLSNumber` = '12690763' ,`ListAgentFullName` = 'Juan Barron' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680583' ,`Longitude` = '-95.195452' ,`PhotoCount` = '11' ,`PostalCode` = '77502' ,`RoomCount` = '3' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Trimm' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s your chance to own a home. Hardwood flooring in living areas + bedrooms. Several updated double paned, low E windows. Double wide driveway with large, 20\'x24\'carport big enough for 4 cars. Covered 14\'x22\' back porch and fenced yard. Large closets, one of which is walk in, another is cedar lined. Ceramic tile bath area. Quiet street close to shopping and schools!' ,`Acres` = '0.157' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 10 FRONTIER EAST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Frontier East Sec 02' ,`TaxAmount` = '3000' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587754' WHERE `Matrix_Unique_ID` = '214044059' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214067915','1667587754','214067915','2022-11-04T06:57:40.477','66269745','Elizabeth Cencini','HOUSTON TOP REALTY','','','29.921670','-95.088252','50','77532','3','292530.00','Active','Kingscoate','16502','Drive','Crosby','2','0','3','1994','Single-Family','Nestled among beautiful trees and lovely neighboring homes this Deerpointe property offers you 3 bedrooms on a grand size corner lot of 17,337 sqft. This home is not your average home, it has some attractive features that must be seen! The home has a spacious living area with high ceilings, a fireplace a second floor media room that overlooks the living area, dining and breakfast area. Enjoy cooking in this very spacious kitchen with plenty of cabinet space, beautiful hardware, soft lighting, and an island that comes with a cooktop on granite countertops. This home also has beautiful views from the primary bedroom, the kitchen area and the porch! The double doors in the primary room will allow you to step into your sunscreened porch. Golfcarts are welcomed with access to the garage and be sure enjoy your hot summers enjoying the amenties on the golf course. The home has a lot of natural lighting coming in from all the windows and has very unique floorplan that most will really enjoy!','0.398','1','','','Washer Connections','','Sellers Disclosure','','','1','Crosby Area','Central Electric','1','LT 22 BLK 2 DEERPOINTE SEC 1','Corner,Subdivision Lot','17337','Appraisal District','','55','0','','2','','0','','','Electric Cooktop','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Deerpointe Sec 01','5293','2.7105','Public Sewer,Public Water','1986','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214098586','1667587754','214098586','2022-11-04T07:54:05.517','53580626','Birdie Blackburn','REB365','','','29.727233','-95.376538','50','77004','10','639900.00','Active','Blodgett','1914','Street','Houston','3','1','3','3008','Single-Family','','0.0543','17','','','','','Sellers Disclosure','1','','0','Rice/Museum District','Central Gas','0','LT 3 BLK 1 BLODGETT AVENUE TERRACE','Other','2365','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','MACGREGOR ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','3','Contemporary/Modern','Riverside Terrace 1st Sec','11992','2.3307','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:41:06.880' ,`MLSNumber` = '65433614' ,`ListAgentFullName` = 'Kimberly Thorpe' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221100' ,`Longitude` = '-95.539807' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '5' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Kerry Bog' ,`StreetNumber` = '349' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY SPECTACULAR VIEWS IN THIS 3-3-2+ RARE FIND LOCATED IN A 55+ DEL WEBB THE WOODLANDS ACTIVE COMMUNITY* THIS BEAUTIFUL HOME COMES WITH LOTS OF FEATURES*LARGE ISLAND KITCHEN WITH A BREAKFAST BAR*DOUBLE OVEN*GAS STOVE TOP*BREAKFAST AREA WITH PLANTATION SHUTTERS*SPACIOUS DEN, SUNROOM, AND ENTRY WITH ENGINEERED WOOD FLOORING*LOTS OF WINDOWS IN DEN,SUNROOM AND PRIMARY BEDROOM WITH VIEWS OF WATER FOUNTAIN AND LAKE/POND*LARGE LAUNDRY ROOM WITH SINK*DROP ZONE BY GARAGE ENTRY*LOTS OF STORAGE SPACE*LARGE PATIO WITH OUTDOOR KITCHEN AND ELECTRIC SUNSCREEN SHADES*GREAT FOR ENTERTAINING FRIENDS AND FAMILY*THE GARAGE IS OVERSIZED SO YOU HAVE ROOM FOR 2 CARS AND A GOLF CART*EPOXY FLOORING IN THE GARAGE*TANGERLY OAK FLOOR PLAN WITH A SUNROOM*WALK OUT OF YOUR BACKYARD TO THE WALKING TRAILS*LOTS OF AMENITIES IN THE NEIGHBORHOOD*PICKLE BALL COURTS, TENNIS CORTS,BOCCEE BALL,2 POOLS,LODGE, EXERCISE EQUIPMENT*GREAT LOCATION*GROCERY STORES,RESTAURANTS,WOODLANDS MALL,HOSPITALS ALL CONVENIENTLY LOCATED' ,`Acres` = '0.1978' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402302 - DEL WEBB THE WOODLANDS 02, BLOCK 1, LOT 26' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '8618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands 02' ,`TaxAmount` = '9326' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587755' WHERE `Matrix_Unique_ID` = '214123016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:51:52.547' ,`MLSNumber` = '30253256' ,`ListAgentFullName` = 'Melissa McCracken' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.326459' ,`Longitude` = '-95.691790' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '915000.00' ,`Status` = 'Active' ,`StreetName` = 'Emmett' ,`StreetNumber` = '4254' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold \"As Is\" - seller is negotiable and highly motivated for a quick sale!! Send all offers. Buyer to purchase survey. Luxury country living at its finest! Stunning custom 1 story ranch home tucked away on a gorgeous \r\ntree-lined 4.84 acre lot w/sparkling pool & spa. Chef\'s Kitchen with eat in breakfast area. \r\nFormal Dining Room with beautiful natural lighting. Large living room with cozy wood burning \r\nfireplace. Large Gameroom w/wet bar & cozy wood burning fireplace. Original 3 car garage \r\nconverted into a boutique w/laminate flooring, water, electric, air conditioning & powder room. \r\nCould be used as rental income. Also, has a 3,600 sq. ft. metal workshop w/3 garage doors\r\n/electric. Don\'t miss out. Make your appointment today!' ,`Acres` = '4.843' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Exclusions,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'S822200 - RACHEL AND GRACE ESTATES 01, BLOCK 1, LOT 3, ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '210961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rachel & Grace Estates 01' ,`TaxAmount` = '9666' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587755' WHERE `Matrix_Unique_ID` = '214134498' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214143132','1667587755','214143132','2022-11-04T07:04:45.377','45697254','Mark Raisbeck','RE/MAX Elite Properties','','','30.029588','-95.608113','24','77377','7','225000.00','Active','Oakner','11831','Drive','Tomball','2','0','3','1472','Single-Family','This 2-story home is located in the Westbourne Subdivision in Tomball. This adorable 3 bedroom, 2 bathroom house has a nice floor plan with the primary bedroom, kitchen and living room down with game room and 2 bedrooms and a full bathroom up! The kitchen is open to the family room, which has a fireplace and soaring ceilings in a very light and airy feeling. Lots of windows. Located on a quiet cul-de-sac and just a block away from the neighborhood school and playground. Easy access to SH 249 and Toll road 99.','0.101','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Tomball South/Lakewood','Central Gas','1','LT 26 BLK 8 WESTBOURNE SEC 1 PAR R/P','Cul-De-Sac,Subdivision Lot','4400','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Other Style,Traditional','Westbourne Sec 01 Pt Repla','3931','2.5764','Public Sewer,Public Water,Water District','1984','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214225134','1667587755','214225134','2022-11-04T07:24:30.897','95098594','Julie Woods','RE/MAX Space Center-Clear Lake','','','29.545038','-95.207655','37','77546','11','920000.00','Active','Southfield','505','Drive','Friendswood','3','0','3','3667','Single-Family','Step into the grand entry of this beautiful Brentwood custom home & you will know this family made many wonderful memories here. Lot is largest & most private in Northfield Estates. Enjoy the salt water pool with water feature, hot tub, sunning deck & in-pool table and seats. 3 car garage attached to house and 2 car detached with carport & 1,300 sf space above the garage ready for whatever you can dream. Throughout the home you will notice custom crown molding, amazing door & window casings, beautiful ceilings, built-in cabinets & shelves. Incredible oversized dining room for family gatherings. Private study w/built-ins. Kitchen includes double ovens, silestone counters, butcher block island w/sink & separate bar area. Primary en suite is tucked away beside the living room w/features like a sitting area, rainfall shower, jetted tub & AMAZING closet! Secondary bedrooms/bathrooms have their own den/playroom area. Download \"Features & Upgrades\" sheet for all the details.','0.675','33','Brentwood','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Friendswood','Central Gas','1','NORTHFIELD ESTATES (2008) ABST 20, BLOCK 1, LOT 11, ACRES 0.','Cul-De-Sac,Subdivision Lot','29401','Appraisal District','','575','0','','5','Convection Oven,Double Oven,Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','20 - Friendswood','WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Northfield Estates','16935','2.2832','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:22:59.793' ,`MLSNumber` = '2627615' ,`ListAgentFullName` = 'Kiera Quinney' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.083440' ,`Longitude` = '-95.527933' ,`PhotoCount` = '20' ,`PostalCode` = '77379' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Saragosa Pond' ,`StreetNumber` = '21831' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! The most gorgeous 1 story; 3-bedroom 2-bath home with a den. Architectural arches, natural paint palette,\r\nopen concept island kitchen, and granite countertops! Spacious primary with French doors to en-suite bath (tub/separate\r\nshower, dual vanities, and walk-in closet). Backyard features delightful extended patio with ceiling fan. The sale of the home\r\nwill include: refrigerator, washer/dryer, 75in. TV (with wall mount), and 55in. TV (with wall mount). Don\'t let this deal pass you by!' ,`Acres` = '0.1263' ,`Area` = '14' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 SPRING TERRACE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Terrace' ,`TaxAmount` = '5786' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587755' WHERE `Matrix_Unique_ID` = '214230684' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214271924','1667587755','214271924','2022-11-04T07:25:31.313','58848036','Alexandra Hampson','Hampson Properties','','','29.745992','-95.603174','18','77077','4','299000.00','Active','Whittington','12507','Drive','Houston','2','1','4','2006','Single-Family','Looking for a fixer-upper? Look no further. This home offers 4 bedrooms, formal dining, a living room, and an amazing backyard. Needs TLC but is situated on an amazing lot close to everything Houston has to offer. Call today for your private tour.','0.2002','31','','','','','Sellers Disclosure','','','1','Energy Corridor','Central Gas','1','LT 2 BLK 4 ASHFORD SOUTH SEC 1','Subdivision Lot','8720','Appraisal District','','700','0','','1','','0','','','','','Composition','27 - Houston','ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Ashford South Sec 01','5929','2.3307','Public Water','1969','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:51:14.887' ,`MLSNumber` = '64655860' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = 'Marcia Kyanka' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '29.766998' ,`Longitude` = '-95.402183' ,`PhotoCount` = '38' ,`PostalCode` = '77007' ,`RoomCount` = '11' ,`ListPrice` = '709900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'GIBSON' ,`StreetNumber` = '4206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. This MAZZTAO HOME located in the Museum District/Medical Center features a new, stylish, well priced, quality home, but with an entirely different price point. This home features an extremely versatile and functional floor plan. This floor plan features 3 bedrooms, 2.5 bath rooms, 1st floor living, primary w/ sitting area, 2 primary closets, flex room, a modest 589 S.F. backyard, and a private driveway. Rice/Museum District is minutes to The Medical Center, The Zoo, Downtown, the newly renovated Memorial Park Conservatory, White Oak & Buffalo Bayou Greenway Parks & Trails, and plenty of Restaurants and Retail. Minutes to Downtown Houston, Galleria, and easy assess to I-69/US-59, 288, I-10, 610, and 45.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 MARTIN 5TH PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'MARTIN 5TH PAR R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667587755' WHERE `Matrix_Unique_ID` = '214296772' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214298370','1667587756','214298370','2022-11-04T07:56:52.697','43982207','Hephzibah Navarro','Zarco Realty','','','29.951137','-95.493984','20','77066','8','285995.00','Active','Taylor Leigh','11902','Lane','Houston','2','1','4','2401','Single-Family','Home in NW Houston is minutes from Sam Houston PKWY, 249, 1960 and major shopping areas. Upon entering the house you have a formal dining room. The spacious kitchen has a walk in pantry. Kitchen and breakfast area over look the grand backyard and living room. Upstairs is a game room along with all 4 bedrooms. Primary bedroom has two walk in closets! Primary bathroom has separate shower and tub along with dual sinks. Schedule your showing today!','0.1455','13','','','','','Mud,Sellers Disclosure','','','1','1960/Cypress Creek South','Central Gas','1','LT 26 BLK 2 COPPER FALLS','Subdivision Lot','6336','Appraisal District','','460','0','','2','','0','','','','','Composition','32 - Klein','MCDOUGLE ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','WUNDERLICH INTERMEDIATE SCHOOL','Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Copper Falls','5142','2.9105','Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T07:37:06.647' ,`MLSNumber` = '59755225' ,`ListAgentFullName` = 'Qian Zhang' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985946' ,`Longitude` = '-95.689576' ,`PhotoCount` = '11' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Orchard' ,`StreetNumber` = '17523' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF INSTALLED in 2022! COZY ONE STORY HOME WITH AN OPEN FLOOR PLAN. 4 SPACIOUS BEDROOMS & 2 FULL BATHS. LIVING HAS TILE FIREPLACE & VAULTED CEILING. TILE IN BREAKFAST/DINING AREA. KITCHEN FEATURES TILE, BREAKFAST BAR, GRANITE COUNTERS, TILE BACKSPLASH, AND 42\' CABINETS. LARGE UTILITY ROOM HAS BUILT-IN SHELVES. MASTER BATH INCLUDES DUAL SINKS, GARDEN TUB & SEPARATE SHOWER. PLENTY OF ROOM TO ROAM IN BACKYARD. SPRINKLER SYSTEM. MOVE-IN READY; THIS HOUSE WILL NOT LAST LONG!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 CYPRESS MILL PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Mill Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587756' WHERE `Matrix_Unique_ID` = '214311842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T06:44:06.540' ,`MLSNumber` = '39739795' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135933' ,`Longitude` = '-95.649273' ,`PhotoCount` = '35' ,`PostalCode` = '77362' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Decker Oaks' ,`StreetNumber` = '32114' ,`StreetSuffix` = 'Drive' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing opportunity to own a beautiful 3 bedroom 2.5 bathroom in the Village of Decker Oaks. Primary Bedroom on the first floor with an abundance of windows to bring in natural light. The formal dining area as you enter the home is welcoming and could be used as a study. High ceilings in the living area and open to the kitchen make this a perfect home for entertaining. Second floor offers an open area and two secondary bedrooms and bathroom. Plantation shutters, cozy corner fireplace in living room and luxury vinyl plank floors. Low Montgomery County taxes, easy access to 249, and Tomball schools is a rare combo! Schedule your showing today to view this great property.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE OF DECKER OAKS 01, BLOCK 5, LOT 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village of Decker Oaks' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587756' WHERE `Matrix_Unique_ID` = '214322442' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214357581','1667587756','214357581','2022-11-04T07:58:10.990','2303426','Caroline Morrison','Keystone Signature Properties','','','30.241569','-95.720693','50','77354','9','769000.00','Active','Mill','41121','Drive','Magnolia','4','1','3','3143','Single-Family','STUNNING home situated on 2.68 secluded acres! It is a staycation every day at this property with a breathtaking backyard featuring a saltwater pool with rock features, a swim-in grotto waterfall, hot tub, and multi color LED lighting! HVAC system replaced 2016, roof replaced 2016, Leaf Guard Lifetime gutters added 8/2020, added whole home generator 6/2020, carport (not pictured) added 2016, exterior of home painted 9/2022, interior painted in main living areas 9/2022, new gas range 7/2022, wall mounted garage door opener added 2016 (for big door). Home has 2 primary bedrooms with en-suite bathrooms! Fully remodeled garage apartment with full bathroom, kitchen and private covered balcony 9/2021! Come take a look, I know you will fall in love!','2.68','15','','','Electric Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure','1','','0','Magnolia/1488 West','Propane','1','MILL CREEK LANDING 01, BLOCK 1, LOT 1A,1-B-1, ACRES 2.680','Subdivision Lot,Wooded','116741','Appraisal District','','60','0','','3','Gas Oven','1','Gunite,In Ground','','Gas Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal','1','Traditional','Mill Creek Landing 01','8273','1.9722','Septic Tank,Well','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214383860','1667587756','214383860','2022-11-04T07:25:49.737','15382783','Nicole Fowler','Compass RE Texas, LLCHeights','','','29.813066','-95.387925','26','77009','8','465000.00','Active','29th','834','Street','Houston','2','0','3','2026','Single-Family','Bright & modern two-story in hip & trendy Sunset Heights. Freshly painted interior & newly refinished hardwoods make this home show like new. Soaring ceilings in the living room with expansive windows elevate the feeling of luxury while the neutral color palette invite you to settle in & relax in that feeling of \"home\". The split floorplan offers a private primary suite with direct access to the covered patio & fully-fenced backyard. Relax in the oversized jetted tub & ready for the day in the roomy primary bathroom. Upstairs, the home is built for entertaining. The open-concept kitchen, dining & living space are perfect for hosting. Sleek, black granite counters, gorgeous custom cabinetry, SS appliances & walk-in pantry make the kitchen a focal point. Two sizable bedrooms & second bathroom also located on the second level are perfect for guests or a home office. Easy access to Loop 610 makes commuting around Houston a cinch. You won\'t miss a minute of all things Houston has to offer!','0.0689','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Heights/Greater Heights','Central Electric','0','LT 17 BLK 9 SUNSET HEIGHTS','Subdivision Lot','3000','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','FIELD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Mediterranean,Traditional','Sunset Heights','9765','2.3307','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214395199','1667587756','214395199','2022-11-04T07:26:37.813','35468283','Helen Huang','Newhall Realty, LLC','','','29.659220','-95.686970','33','77407','12','755000.00','Active','Endel','17323','Way','Richmond','4','2','5','4290','Single-Family','Beautiful Highland home located in the highly sought community of Aliana with a lot of space for entertaining & gathering. The home features 5 bedrooms (2 down), 4/2 baths and 3-car garage. 2-story foyer with high ceiling, hardwood floor in all common areas, plantation shutters throughout the house, built-in bookshelves & French doors in study, formal dining connected to the open kitchen area having a large island, gas cooktop & walk-in pantry. The 10\" ceiling master suite has bay windows with lots of natural sunlight, large bath and shower with his/her vanities, garden tub & big walk-in closet. The 2nd floor features Game room, Media room, 3 bedrooms & 2/1 baths. A huge backyard with covered patio ready for summer kitchen and a big pool. Unique location with great privacy. Walking distance to parks & trails, club houses. Brand new coil of the largest AC unit. Exemplary FBISD schools, safe neighborhoods, & easy access to major HWYs. This amazing home has it all!','0.2715','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Sugar Land West','Central Gas','1','ALIANA SEC 17, BLOCK 4, LOT 9','Subdivision Lot','11828','Appraisal District','','1137','0','','3','Convection Oven,Single Oven','0','','','Electric Range','','Composition','19 - Fort Bend','MADDEN ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Supra Keybox','Builder','2','Traditional','Aliana Sec 17','13721','2.9329','Public Sewer,Public Water','2014','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214401688','1667587756','214401688','2022-11-04T07:01:39.990','66053632','Wanda Simons','RE/MAX Associates Northeast','','','30.111882','-95.311499','48','77365','13','1090000.00','Active','Serpenteer','19223','Drive','Porter','5','1','4','6814','Single-Family','Welcome to a stunning example of contemporary style in this never-lived-in 3-story home! Located on just over 1 acre, it is nestled among beautiful trees close to private Lake access within the exclusive Riverwalk community. Walking in, the first impression is a grand, vaulted entry opening into a sprawling Kitchen/Living Room space with tons of natural light from a wall of panoramic windows. And wow - the Kitchen with its massive 10-ft island is a swoon-worthy chef\'s dream! Also on this main floor are two cathedral-like large bedrooms with soaring ceilings, gorgeous natural light and private bathrooms. The luxurious Primary Suite encompasses the ENTIRE 3rd floor with two separate, spa-inspired bathrooms and enormous walk-in closets. Lastly, the fun lower floor has tons of extra space with game room/office; huge media room; workout studio; full guest suite & bath and large flex space. Professionally appraised at over $1,400,000.00, this home is a fantastic opportunity and a must-see!','1.02','40','S. White','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','Gaslog Fireplace','1','Porter/New Caney West','Central Gas','1','S834903 - RIVERWALK 03, BLOCK 1, LOT 7, ACRES 1.02','Subdivision Lot','44431','Appraisal District','','450','1','Never Lived In','2','Double Oven','0','','','Gas Cooktop','','Composition','39 - New Caney','SORTERS MILL ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal','3','Contemporary/Modern','Riverwalk 03','11798','2.1331','Aerobic,Water District','2020','Appraisal District'); --> New record created successfully